Forum Discussion

Seek08's avatar
Seek08
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper 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
Icon for Super User rankSuper User
2 years ago

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

  • Seek08's avatar
    Seek08
    Icon for Helper I rankHelper 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
      Icon for Super User rankSuper User
      2 years ago

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