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.
Good morning,
I am totally stuck!
I have a table of values for which I have created a measure.
what I need to do is to create a new measure such that it returns only the worst performer.
i.e. Measure = "ModalityValue" where Value = Worst(Min) Value".
in the example above I would want it to return "Non-Obstetric Ultrasound".
Does anyone have any ideas please?
Kind regards
Steve
PS the measure value 94K is created from
VariationActAv min per Modality =
MINX(
KEEPFILTERS(VALUES('Modalities'[Modality])),
CALCULATE([VariationActAv])
)
Solved! Go to Solution.
P.S. In the measure you wrote, you don't need KEEPFILTERS on top of VALUES, becasue VALUES already keeping all the filters, and you also didn't need to write calculate as a measure reference already get's an implicit calculate around it.
P.S. In the measure you wrote, you don't need KEEPFILTERS on top of VALUES, becasue VALUES already keeping all the filters, and you also didn't need to write calculate as a measure reference already get's an implicit calculate around it.
Perfect - thank you so much - and thank you for the tips.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |