Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi forum,
I did some research, but unfortunatelly could not find a fitting solution:
I have my products connected with the meassure "Cumulative_%_Revenue"
Now, I want to create
Can anybody please help me in creating the corresponding measure?
Thank you so much!
Mister_T
Example data:
Product A | 25% |
Product B | 49% |
Product C | 63% |
Product D | 73% |
Product E | 82% |
Product F | 89% |
Product G | 95% |
Product H | 97% |
Product I | 99% |
Product J | 99% |
Product K | 100% |
Solved! Go to Solution.
Hi @Mister_T
Is your Cumulative_%_Revenue DAX Measure?
Min Value =
VAR T1 =
ADDCOLUMNS ( VALUES ( yourTable[Product] ), "Target", [Cumulative_%_Revenue] )
VAR Threshold = 0.9
RETURN
MINX ( FILTER ( T1, [Target] >= Threshold ), [Target] )
Hi @Mister_T
Is your Cumulative_%_Revenue DAX Measure?
Min Value =
VAR T1 =
ADDCOLUMNS ( VALUES ( yourTable[Product] ), "Target", [Cumulative_%_Revenue] )
VAR Threshold = 0.9
RETURN
MINX ( FILTER ( T1, [Target] >= Threshold ), [Target] )
Thank you very much @Vera_33! Your solution works perfect for getting the first value higher then the threshold!
Yes, "Cumulative_%_Revenue" is a DAX meassure.
Just for completing the solution for other readers with the DAX meassure for getting the last value smaller then the threshold:
Max Value =
VAR T1 =
ADDCOLUMNS ( VALUES ( yourTable[Product] ), "Target", [Cumulative_%_Revenue] )
VAR Threshold = 0.9
RETURN
MAXX ( FILTER ( T1, [Target] <= Threshold ), [Target] )
Best regards,
Mister_T
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |