Measure Formulas shouldn't apply to row subtotals

[msantillan]

Hi, was wondering if there was a way where Measure forumlas won't apply to row subtotals.

I have this measure: 

IF([Measure 6]<>0,CALCULATE((([Measure 5]*[Measure 6])/10000)),0)

However, it seems that the row totals are also affected as seen below, when I only want it applied to the values. Whiles the subtotals should only be the sum of all values: 

This is what the value should be like:

Please help.

[v-easonf-msft]

Hi , @msantillan 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread?

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Use isfiltered or hasonevalue to control the same

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[msantillan]

@amitchandak Can you please help me on how I can implement it on my measure? Thanks

[v-easonf-msft · Accepted solution]

Hi , @msantillan 

May be you can refer to this article:

https://community.powerbi.com/t5/Desktop/Calculation-for-subtotal-row/m-p/927590

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.