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