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,
I need a sub total in each group, but why the calculation incorrect. I use matrix table for this report and already set sub total
My DAX calculation is:
Any help would be appreciated. Thanks!
Solved! Go to Solution.
@akhmad_danial , when every you use if and switch then it needs a row context of table. and that context is missing at sub total and total level. If user filter clause then we remove that data and sum it up to we will get the correct subtotal.
If possible use filter in place of filter data in Switch, use a switch to change calculations
In the above case force a row conetxt from the lowest level like this example
sumx(summarize(Table,Table[class], table[country],"_1",[Budget]),[_1])
Here data is first groped at Table[class], table[country] level then used. You can have more or less level as per need
Hi @akhmad_danial ,
I agree with @amitchandak. You could use the formula that he suggests to have a try. If you can't implement or you have other questions, please share some sample data and your expected output. We will understand clearly about your situation.
@akhmad_danial , when every you use if and switch then it needs a row context of table. and that context is missing at sub total and total level. If user filter clause then we remove that data and sum it up to we will get the correct subtotal.
If possible use filter in place of filter data in Switch, use a switch to change calculations
In the above case force a row conetxt from the lowest level like this example
sumx(summarize(Table,Table[class], table[country],"_1",[Budget]),[_1])
Here data is first groped at Table[class], table[country] level then used. You can have more or less level as per need
Hi All @amitchandak @v-xuding-msft
Thank you for your responded.
Idea provided by @amitchandak worked, I changes the rule of filter in group first to get value correctly and calculate it.
Thank you very much.
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |