Forum Discussion

Deermeat's avatar
Deermeat
Resolver I
4 years ago
Solved

Ranking Values in a Measure

Hello, I have two measures that I used to calculate the average of Score and YTM over different industries:   YTM (Mid) = AVERAGEX( KEEPFILTERS(VALUES('Data (All Issues)'[Industry])), CALCULAT...
Need Help
Tutorial Requests
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may refer to my solution in this file.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

You may refer to my solution in this file.

Hope this helps.

  • Deermeat's avatar
    Deermeat
    Resolver I
    4 years ago

    Hi Ashish_Mathur,

     

    Thank you so much. That has indeed helped me to solve this problem.

     

    For anyone curious, Ashish used this code:

    ActualRank = CALCULATE(MAX('Data (All Issues)'[Industry]),FILTER(ADDCOLUMNS(VALUES('Data (All Issues)'[Industry]),"ABCD",CALCULATE([Ranking],CALCULATETABLE(VALUES('Data (All Issues)'[Industry])))),COUNTROWS(FILTER('Rank',[abcd]='Rank'[Rank]))>0))

    With a new rank table that just has the numbers of industry in it for the rows.

     

    Once again, thank you Ashish!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      4 years ago

      You are welcome.