Correct row values but wrong grand total value

[eunji888888]

I have created the measure:

Measure = SUM('table'[value])/SUM('table'[Qty])

It gives the correct row values but wrong in grand total.

Do anyone have the idea to solve this problem?

[Ritaf1983 · Accepted solution]

Hi @eunji888888 "
Try :

Measure = SUMx('table','table'[value])/SUM('table'[Qty])

If it won't work :

please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[vicky_ · Accepted solution]

it's a common "problem". see the following blog post - https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/5... or https://www.sqlbi.com/articles/summing-values-for-the-total/ 

but tldr your measure is returning the value (in the totals row) / the qty (in your total row), which i suspect is not what you want.

[Ritaf1983 · Accepted solution]

Hi @eunji888888 "
Try :

Measure = SUMx('table','table'[value])/SUM('table'[Qty])

If it won't work :

please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly