Best approach to rank + ratio of measures

[orangeatom]

Hello all,

I need some guidance on creating some measures to deliver a KPI.

I'd like to take the top n customers (denominator) and find out how many of those customers are selling more than x dollars (numerator). Then I will need to present that as a ratio. What is the best way in approaching this?

Direction will be greatly appreciated!

[orangeatom · Accepted solution]

I have found how to accomplish my ambigous request but i'm not sure if this is the most efficient method:

1 - Use the SUMMARIZEDCOLUMNS function with a filter using RANKX

entity =
FILTER(
SUMMARIZECOLUMNS(
entity[attribute],
"column",[attribute]
),
RANKX (
ALL ( entity[attribute] ),
[attribute]
) <= n
)

2 - Create a column flagging x dollars

Flag =
IF(
[attribute] > 0,
1,
0
)

3 - Create measures to get performance

Ratio = ([Indicator]/n)*100

[v-yuezhe-msft]

@orangeatom,

Have you got expected result via the above method? The formulas you post are OK in my opinion. You can accepe your reply as answer,  this way, other community members would easily find the answer when  they get same issues.

Regards,
Lydia