Solved: Customize Total in Matrix

Panbansal · ‎01-26-2018

Hi All,

I am new to power Bi and sort of struggling to fix a issue.

I have a Matrix and I am calculating Price and Volume variance.

Everything is woking fine but price and volume variance are recalculated for Total row. Which I do not want I want the price and volume variance get rolledup.

Any help or advice would be appriciated.

Thanks

Pankaj

Greg_Deckler · ‎01-27-2018

Take a look at my short article here:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Ashish_Mathur · ‎01-27-2018

Hi,

Share a dataset and show the expected result.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Greg_Deckler · ‎01-27-2018

Take a look at my short article here:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...