Change the Subtotal calculation

[aishak12]

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

[v-xulin-mstf]

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

[v-xulin-mstf]

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-colum...

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.

[amitchandak]

@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/