Forum Discussion
Correct row values but wrong grand total value
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
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.
2 Replies
- Ritaf1983
Super User
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_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.