Forum Discussion
Solved
Display the Lowest Value
Hi,
I have this table which I want to display the Country with the lowest ATV, ie Greece.
May I know how to do that?
Thank you very much!
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
It is for creating a measure.
Lowest ATV country measure: = VAR ATVmin = MINX ( ALLSELECTED ( Data ), Data[ATV] ) RETURN CONCATENATEX ( FILTER ( Data, Data[ATV] = ATVmin ), Data[Country], ", " )
1 Reply
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
It is for creating a measure.
Lowest ATV country measure: = VAR ATVmin = MINX ( ALLSELECTED ( Data ), Data[ATV] ) RETURN CONCATENATEX ( FILTER ( Data, Data[ATV] = ATVmin ), Data[Country], ", " )