Forum Discussion

Arshadjehan's avatar
Arshadjehan
Icon for Helper I rankHelper I
6 years ago
Solved

Count of records Based on RANKX

I have dynamically filtered the based based on a slicer options of: Top 3, Top 5 and Top 10. I want to display number of records filtered , e.g when I select Top 3 , records returned after RANKX fun...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Arshadjehan - Given the form of that RANKX calculation it must be a calculated column. Therefore, this should be something like the following:

     

    Male = COUNTROWS(FILTER('Table',[Top N] <= 3 && [Gender]="M"))

Female = COUNTROWS(FILTER('Table',[Top N] <= 3 && [Gender]="F"))