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 ame...
  • 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

  • mjholland's avatar
    mjholland
    Advocate II
    10 years ago

    Sean this isn't working for me. I've given a screenshot below:

     

     

    I've created a really simple table with the list of stores, their % and count of data points (count of entry responses). When I add in the DAX solution you gve me it ranks these stores as 1, when it should really have a different value for each store.

     

    Any thoughts?

    • Sean's avatar
      Sean
      Community Champion
      10 years ago

      mjholland I know this pattern works - so we should probably look at the formulas you are using for

       

      the 2 MEASURES => Entry % and Count of Entries - can you post the formulas?

      • mjholland's avatar
        mjholland
        Advocate II
        10 years ago

        Sean sure here you go:

         

        Entry % = sum('All Mults Data'[Entry Response])/counta('All Mults Data'[Entry Response] )

        Count of Entry = count('All Mults Data'[Entry Response])

         

        Initially I didn't have Count of Entry as a measure, I just has COUNT('All Mults Data'[Entry Response]) in where the second measure would appear, but this didn't work either.