Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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
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
@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
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |