Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |