Forum Discussion
Post Prodigyquick 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
v-lili6-msftCommunity Support
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
jcastr02v-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
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?
- amitchandak
Super User
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])))
- Greg_Deckler
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
