Find minimum value in a dynamic breakdown (field parameter) chart

Anonymous — Sat, 28 Jan 2023 11:33:20 GMT

Hi,

I am trying to get the lowest total (amongst all the Job Levels) in by chart below:

To do that I am using this calculation:

MINFTE = MINX(ALLSELECTED('1'[Job Level]) , CALCULATE(SUM('1'[FTE])))

However, it works when my Y-axis is fixed.

If I want to let the user change the Y-axis, I do it using Field Parameter:

But then my previous calculation to find the minimum does not work - as I have fixed dimension there, and also revised calculation below does not work:

MINFTE2 = MINX(ALLSELECTED('Breakdown By'[Breakdown By]) , CALCULATE(SUM('1'[FTE])))

I will need this minimum value in a measure so I can use it in other calculations.

Is it possible ?

My data structure is quite simple (in case you need it):

Thanks.

topic Find minimum value in a dynamic breakdown (field parameter) chart in DAX Commands and Tips

Find minimum value in a dynamic breakdown (field parameter) chart