quick measure total points

[jcastr02]

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)   

[v-lili6-msft · Accepted solution]

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]

@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]

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]

@v-lili6-msft   using a gauge visual, see below....

[v-lili6-msft]

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

[jcastr02]

Disregard , this worked it was how my data type was set up, thanks so much! @v-lili6-msft 

[jcastr02]

@v-lili6-msft     If I use a line chart, the number tends to stay consistent,  if I use a gauge chart, there is only that one roll up value, so it works... 

[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

[amitchandak]

@jcastr02 

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])))