display text value associated with a calculated value

[SteveIOW]

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])

)

[SpartaBI · Accepted solution]

@SteveIOW 

TOPN(1, VALUES(Modalities[Modality]), [VariationActAv], ASC)
 I guess [VariationActAv] is a measure so we don't need a calculate around it.
In case you only have 1 value it will transform this table result into a scalar value and you could put it in a card visual. In case there is a tie in the 1st place this measure will break. You can wrap it up with CONCATENATEX and decide how you want to present 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.

Showcase Report – Contoso By SpartaBI

     

[SteveIOW]

Perfect - thank you so much - and thank you for the tips.

[SpartaBI]

@SteveIOW my pleasure 🙂