Forum Discussion

aishak12's avatar
aishak12
Icon for Helper IV rankHelper IV
5 years ago

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 c...
Need Help
v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
5 years ago

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

https://community.powerbi.com/t5/Desktop/Divide-the-sum-of-a-column-member-by-the-total-of-all-columns/m-p/1705198

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.