Forum Discussion

Seek08's avatar
Seek08
Helper I
2 years ago

Dax Help

Hi Community, I need help on below issue: In one of report page there is One Field Parameter and One Slicer to toggle between top and bottom to select top 5 and bottom 5. Field Parameters contains ...
Need Help
Seek08's avatar
Seek08
Helper I
2 years ago

Thanks for responding.

I used Rankx(summarize(filter - and filtered out blanks and instead of declarion I used in switch and query time now reduced to ~6 sec. KPI1 is divide(a,b) while a is calculated by sumx(because of conversion multiplication).

 

Now, lets say KPI1 has same value for 50 rows e.g. 100% for 50 rows out of 1000. Now to filter out just top 5, this is not working as condition is <=5 so all 50 rows are meeting this condition. I checked other community posts with RAND() to break tie, but that is not working as everything is measure here not column. Do we have any solution for such scneraio.

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    What would be your expected result? Can you sort by another field too?

    • Seek08's avatar
      Seek08
      Helper I
      2 years ago

      There is no other field to sort. See below I just need first 5, even if the next sorting is done by Dimension column(e.g. BrandName here).

       

       

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Your requirement cannot be achieved in a meaningful way given the data that you are showing.