Forum Discussion
Change the Subtotal calculation
Hi All,
This is a table matrix and the grey column is the subtotal field. In Line 3 it is currently adding all three values. In line 7 it is adding them and dividing by 3.
Is there a way to change the calculation of subtotal. I would like to have the subtotal as the last value in the 3rd field. For Example
Line 7 Revenue Factors having a subtotal value of 2.14
3 Replies
aishak12 , Isincope can help you change the calculation
refer to this blog
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Hi aishak12,
I'm not sure about the data structure.
Maybe you can use HASONEVALUE to custom the calculation of subtotal.
If you need a specific dax, please provide pbix file after removing sensitive information.
You can also refer the related post:
https://community.powerbi.com/t5/Desktop/Measure-to-group-by-Month/m-p/1713961
Hope it helps.
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi aishak12
Is you issue solved?
If the issue is solved, could you share the final solution and make it answered?
So that it can help others.
Best Regards,
Link
