Forum Discussion

mjholland's avatar
mjholland
Advocate II
10 years ago
Solved

Ranking 2 Measures and Filtering

Hi,

 

I'm looking to rank a list of stores based on 2 calculations - one a measure working out a percentage, the other would be the count of a field. I then want to be able to have this ranking amend based on a number of filters and slicers I apply to the report.

 

My data has a large number of data points for each store, relating to question responses. For each store I'm able to work out a % for these responses by quarter. I'm looking to identify the top stores by ranking those with the highest % reponse with the largest number of data points (count of data field). The result would be to show to the top and bottom stores.

 

I would need the ranking to be affected by a number of filters.

 

Any suggestions as to how I could do this?

 

Thanks,

MJHolland

 

 

  • Sean's avatar
    Sean
    10 years ago

    mjholland on the 3rd, 4th and 6th lines ONLY add the column name

     

    so it will look like => ALL ( 'All Mults Data'[Branch Name] )

     

    Also change to counta the 2nd measure or the 1st to count depending on your data type

7 Replies