Subtotals in power bi wrong

[AnilKumar]

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

[amitchandak]

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.

[v-qiuyu-msft · Accepted solution]

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