Return category name based on lowest average

[Anonymous]

Hello community,

I am trying to create an automatically updateable report with text that changes depending on the data.

I want to write: "You score the lowest on {this category}"

Therefore i need to first extract the lowest value which is calculated as the average of "Besvarelser[Indekskolonne]", and then get the right value name from the "Spørgeskema[Spørgsmål]".

In the bar chart at the bottom i have created the charts by filtering the chart by each value in "Spørgeskema[Spørgsmål]" and then added the value as "Average of Besvarelser[Indekskolonne]".

Is there anyway to automatically make it say "You score the lowest on Har jeg været glad og i godt humør", as that is the lowest score?

Current code is:

MentalSundhedTekst =

DISTINCTCOUNT(Besvarelser[Respondent ID])

& " har besvaret spørgeskemaet."

& UNICHAR ( 10 )

& IF([Indeksscore]>[OverordnetBenchmark],"Jeres indeksscore ligger over benchmarket med ", "Jeres indeksscore ligger under benchmarket med ")

& FIXED([Indeksscore]-[OverordnetBenchmark],0) & " procentpoint"

& UNICHAR ( 10 )

& "I scorer lavest på" & (CALCULATE(MIN(Besvarelser[Indekskolonne])))

[amitchandak]

@Anonymous , we can create a rank on category ascending and if that is 1 we can say lowest in category

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://www.youtube.com/watch?v=DZb_6j6WuZ0

[Anonymous]

I have succesfully created a rank called "Rangering" however I can't figure out how to get the expression out in text.

CALCULATE(SELECTEDVALUE('Spørgeskema'[Spørgsmål]),([Rangering])) ?