Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |