Forum Discussion

KMcCarthy9's avatar
KMcCarthy9
Helper V
5 years ago

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...
Need Help
Tips and Tricks
KMcCarthy9's avatar
KMcCarthy9
Helper V
5 years ago

Hi amitchandak , I'm sorry I do not understand your reply. Could you elaborate more? The slicer is responding correctly where it gives me only the volume I set the range for, however if I want to see the Top 5 vendors, it shoulde be giving me 5 vendors not 4. Is there a way to do this? I have attached my .pbix file above. 

 

Thank you. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

KMcCarthy9 

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.

  • KMcCarthy9's avatar
    KMcCarthy9
    Helper V
    5 years ago

    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.