Not Getting total while using switch statement

[Rishabh_Jain_31]

Hello All, 

Can someone please help me resolve an issue, I am using switch statement in my report and I am getting correct value for the logic I have fedin but the total is coming out to be blank(As it is just showing value for the specific row), How to solve the issue?

This is the output I am getting I want the value of cprrect result in Total part too.

Thanks

[amitchandak · Accepted solution]

@Rishabh_Jain_31 , Assume you measure is M1,

Then you need a measure like

sumx(values(table[Column1]), [M1] )

Refer: https://www.youtube.com/watch?v=ufHOOLdi_jk