Forum Discussion
Solved
Need help in Measure for % Calculation
Hi, I have a data like below, Name Rating QTR ABC 5 Q1 CDE 6 Q1 ABC 6 Q2 BCD 6 Q2 CDE 3 Q2 and need something like below: If filtered by QTR(Q1) QTR ...
May be a MEASURE like
Measure = COUNT ( Table1[Rating] ) / CALCULATE ( COUNT ( Table1[Rating] ), ALLEXCEPT ( Table1, Table1[QTR] ) )
May be a MEASURE like
Measure =
COUNT ( Table1[Rating] )
/ CALCULATE ( COUNT ( Table1[Rating] ), ALLEXCEPT ( Table1, Table1[QTR] ) )