Forum Discussion
Helper IISubtotals in power bi wrong
Hi all,
I have created a dax which takes parameter from another table and calculates the results(attachment). Where the sub totals are showing wrong results.
Please share your ideas to resolve it.
Thanks in Advance,
Vishnu Priya
Hi AnilKumar,
It looks like you want to get sum total of measure values, right?
You can modify your measure based on this article: https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Best Regards,
Qiuyun Yu
2 Replies
v-qiuyu-msftCommunity Support
Hi AnilKumar,
It looks like you want to get sum total of measure values, right?
You can modify your measure based on this article: https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Best Regards,
Qiuyun Yu- amitchandak
Super User
This multiplication
Sum(A) * Avg(B), is the one that will cause this. this need a row context. Means a level where it can do and later Aggerated to Sum or Average
Something like this. This averageX can me sumx. Key the group where this will happen correctly. These can be more than one column
averagex(summarize(Table,Table[Key],"_1",[Sum Measure],"_2", [Avg Measure],"_3",[third meausre]),
([_1]* [_2])-[_3])Does the above reply helps. if you need more help make me @
Appreciate your Kudos.
