Forum Discussion
jcastr02
Post Prodigy
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
Greg_Deckler
Community Champion
Community ChampionPlease 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