Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Top N

Greetings,

 

I have seen several examples with a dynamic top N but I just can't seem to get it working in my report.

Could someone have a look at my example ?

 

 I have created below table  for selection -

 

Based on below chart I want to give top n selection.

In the place of Axisi kept Business process type and in the place of value I kept parameter, the measure i have created i.e. 

parameter = VAR X= SELECTEDVALUE(Slider_BP[Value])
VAR Y= CALCULATE(COUNT(Sheet1[Business_Process_Type]),Sheet1[Category]=1)
RETURN
Y

I know i am missingout something in my dax that y the slicer is not working.

Can anyone help me with this?

 

Thank you in advance!

 

 

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Assume you have measure on which you want rank 

     

    measure =CALCULATE(COUNT(Sheet1[Business_Process_Type]),filter(Sheet1,Sheet1[Category]=1))

     

    Rank you want 

     

    rank = rankx(allselected(Sheet1[Business_Process_Type]) ,[measure] )

     

    filter on Rank 
    Rank Top N= CALCULATE(if([Rank]<=SELECTEDVALUE(Slider_BP[Value]),[measure],BLANK()) ,VALUES(sheet1[Business_Process_Type]))

     

    using TOPN 

    Top N = CALCULATE([measure],TOPN(10,all(sheet1[Business_Process_Type]),[measure],DESC),VALUES(sheet1[Business_Process_Type]))

8 Replies