Forum Discussion

Petr_Durana's avatar
Petr_Durana
Frequent Visitor
2 years ago

Percentile over average value

I have table PLAYERS and in it columns YEAR, LEAGUE, PLAYER and %3P. I have slickry over YEAR and LEAGUE columns. I have a visual type table in which the PLAYER and %3P columns are the average valu...
Need Help
bhanu_gautam's avatar
bhanu_gautam
Super User
2 years ago

 , Create a measure  

 

  1. Create a measure that calculates the %3P average for each player in the PLAYERS table:
    %3P Average = AVERAGE(PLAYERS[%3P])

    1. Create another measure that calculates the %3P percentile based on the %3P average: %3P Percentile =
      VAR PlayerAverage = [3P Average]
      RETURN
      PERCENTILE.INC(
      CALCULATETABLE(
      VALUES(PLAYERS[PLAYER]),
      ALLSELECTED(PLAYERS),
      PLAYERS[%3P Average] < PlayerAverage
      ),
      PlayerAverage
      )