Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic

Hello,   Can anyone guide me how to make top 10 business process type dynamic? please refer to the below image -   In the above image top 10 business process type is showing..I want to giv...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak I have edited the post.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Blog I posted may be relevant , check that

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak , I tried by following the link you have shared but it's not working.

     measure that I am using- 

    TopN =
    VAR SelectedTop = SELECTEDVALUE('Parameter'[Parameter])
    RETURN
    SWITCH(TRUE(),
    SelectedTop = 0, COUNT('table'[field]),
    RANKX (
    ALLSELECTED( 'table'),
    COUNT('table'[field])
    )
    <= SelectedTop,
    COUNT('table'[field]))
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      HI Anonymous,

      It should help if you provide a pbix file with some dummy data to test.
      Regards,
      Xiaoxin Sheng

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hello Anonymous , I could do the dynamic top N selection. But the problem I am facing is it's working only on List or on dropdown.

         

         

        I want  to do it on slider. But not working...

         

         

        The measure I am using is = 

        TOPN_BP =
        VAR SelectedTop= SELECTEDVALUE(TopN[TopN])
        Return
        SWITCH(TRUE(),
        SelectedTop=0, [Measure],
        RANKX(
        ALLSELECTED(Table[field]),
        [Measure]
        )
        <=SelectedTop,
        [Measure]
        )
         
         
        Can you tell me why it's not working on slider?