需求

实现

1 度量值 total amount2 =
var v_total = calculate([total amount],removefilters(productnames[])) //
return
if(isinscope(productnames[产品名称]),//第一个参数//下面部分为if的第二个参数，是一整段的DAX表达式var v_Topn_no = [topN参数 值] //获取当前topN参数va rAllProductsWithAmount = addcolumns(allselected(productnames[产品名称]),"Amt",[total amount]) //构建一个在当前上下文中包含产品名称和Amount的表var TopNProducts = Topn(v_topN_no,AllProductsWithAmount,[amt]) //获取topN子表var amountoftopn = sumx(TopNProducts,[amt]) //计算TopN中记录的Amount的总金额var isothersselected = selectedvalue(productnames[产品名称])]="others"var result =  if(isothersselected,v_total - amountoftopn,[total amount]) //判断如果当前行是others,就采用总金额topN的金额return result,v_total // if的最后一参数，处理总计行)

2 计算表 productNames = union(allnoblankrow('product'[产品名称]),{"others"})

3 ranking by amount2 = 
var v_ranking = rankx(allselected(productnames[产品名称]),[total amount])
var isothersselected = selectedvalue(productnames[产品名称])="others"
return if(isothersselected,-1,v_ranking)