Forum Discussion
Find minimum value in a dynamic breakdown (field parameter) chart
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:
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):
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.
No Replies