Forum Discussion
Solved
Create a Combi Chart as in Excel
Hi all, I have a simple data table with retailers, categories and values. Now I want to display the relative ratio of retailers in each category by selecting a category. The calculated values in a...
Hi, MBreden
You can try the following methods.
Measure = Var _N1=[TT Sum] Var _N2=CALCULATE(SUM(Data[Value]),FILTER(ALL(Data),[Retailer]=SELECTEDVALUE(DimRetailer[Retailer]))) Return DIVIDE(_N1,_N2)Average = Var _Sum1=CALCULATE(SUM(Data[Value]),FILTER(ALL(Data),[Category]=MAX(DimCategory[Category]))) Var _Sum2=CALCULATE(SUM(Data[Value]),ALL(Data)) Return DIVIDE(_Sum1,_Sum2)Result:
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, MBreden
You can try the following methods.
Measure =
Var _N1=[TT Sum]
Var _N2=CALCULATE(SUM(Data[Value]),FILTER(ALL(Data),[Retailer]=SELECTEDVALUE(DimRetailer[Retailer])))
Return
DIVIDE(_N1,_N2)Average =
Var _Sum1=CALCULATE(SUM(Data[Value]),FILTER(ALL(Data),[Category]=MAX(DimCategory[Category])))
Var _Sum2=CALCULATE(SUM(Data[Value]),ALL(Data))
Return
DIVIDE(_Sum1,_Sum2)
Result:
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
