Show Matrix Total as 0

[Anonymous]

Hello,

I have a requirement in a matrix.

I am using 5 measures, Switched them as rows, and showing value for each month ( month is in column) & total.

Now out of the 5 , for 2 measures, I need to show Matrix Total ( Column total) as 0 and not the summation of all months in context.

Could you kindly help with the above..

Thanking in advance .

Swathi

@amitchandak @Greg_Deckler @tamerj1 @Sahir_Maharaj 

[Anonymous]

@tamerj1  Thanks alot for the super quick response ..

It works 🙂 

[tamerj1 · Accepted solution]

Hi @Anonymous 

you can try

IF ( 

ISINSCOPE ( 'Date'[Month] ),

[Measure],
0

)