topic Re: Correct row values but wrong grand total value in DAX Commands and Tips

Correct row values but wrong grand total value

eunji888888 — Tue, 18 Jun 2024 04:02:50 GMT

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?

Re: Correct row values but wrong grand total value

Ritaf1983 — Tue, 18 Jun 2024 04:47:42 GMT

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

Re: Correct row values but wrong grand total value

vicky_ — Tue, 18 Jun 2024 04:54:23 GMT

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/547907 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.