Forum Discussion
Dynamic Top/Bottom N Slicer
I currently have a table that lists vendor name, MTTR Days value, and volume of workorders. I created a parameter for the workorder volume so users can choose to look at vendors who have at least X n...
Why don't use the MTTR days in the bottom 5 filter? Or I missed out some information?
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous, the DAX for the MTTR Days Top/bottom measure is:
MTTR Days Top/Bottom =
VAR _MTTRDays = AVERAGE(data[Sup Scorecard ETTR Days])
VAR _All = CALCULATE(COUNTA(data[Sup Scorecard ETTR Days]))
RETURN
IF(_All > 10,
IF(ISBLANK(_ALL), "N/A",_MTTRDays)
)I had it limiting it to at least 10 work orders. However, even after changing that to IF(_All > 0,...) the result does not change. It will give me the Bottom 5, however if I then adjust the paramter slider slicer to limit the volume of work orders it will only give me 4 results and not the 5 it should.