Forum Discussion

Post Prodigy

6 years ago

Solved

quick measure total points

I have two columns - 1. Total Points 2. Max Total Points How can I get a measure to get an average of points (total points / Max total points)

Need Help

v-lili6-msft
6 years ago
hi jcastr02

You could use AVERAGEX Function to create a measure like below:

https://docs.microsoft.com/en-us/dax/averagex-function-dax

= AVERAGEX('Table', DIVIDE(CALCULATE(SUM('Table'[Total Points])),CALCULATE(SUM('Table'[Max Total Points]))))

Regards,

Lin

jcastr02

Post Prodigy

6 years ago

v-lili6-msft I tried to do this, but when I put in visual in gave me error....here is sample data, not sure if this helps....I would want the score to show the roll up of the team members overall score (of all modules).....

Greg_Deckler

Community Champion

6 years ago

So a measure like:

SUM([Total Points]) / SUM([[Max Total Points])
?
What kind of visualization are you using and what are you putting in that visualization?

jcastr02
Post Prodigy
6 years ago
v-lili6-msft using a gauge visual, see below....
- v-lili6-msft
  Community Support
  6 years ago
  hi jcastr02
  
  I hve test on my side, it works well.
  
  here is my sample pbix file, please try it.
  
  If possible, could you please share your sample pbix file and your expected output for us have a test?
  
  Regards,
  
  Lin
  quick measure total points.pbix31 KB
  - jcastr02
    Post Prodigy
    6 years ago
    Disregard , this worked it was how my data type was set up, thanks so much! v-lili6-msft