Forum Discussion
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)
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
9 Replies
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
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).....
- 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?
Can you share sample data and sample output. You can have the calculation like this
Calculate(Average(Table[Total Point]))Calculate(divide(sum(Table[Total Pont]),sum(Table[max Point])))
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
