Show blank as 0 in the matrix

[Anonymous]

For reason when I'm creating a matrix it's not returning 0 where there is blanks.  Can someone help me withis?

All the relevant info is below;

The DAX to calculate the value is 

Value = SUM('DemoP&LData'[TransactionValue]) + 0

Thanks

[Jihwan_Kim · Accepted solution]

Hi,

In my opinion, if you create dimension tables for Code and Department, and then put those into the visualization, -> then the measure with +0 will work to show 0 when the result is blank.
Thanks.

[Anonymous]

@Jihwan_Kim Thank you this worked! 

[Greg_Deckler · Accepted solution]

@Anonymous You're likely running into AutoExist but hard to be 100% sure given the information. If you are, then the formula isn't even evaluated for combinations that AutoExist removes.

[Anonymous]

I haven't come across AutoExist before or even knew it was a thing so I've got some reading to do! @Greg_Deckler 

[Jihwan_Kim · Accepted solution]

Hi,

In my opinion, if you create dimension tables for Code and Department, and then put those into the visualization, -> then the measure with +0 will work to show 0 when the result is blank.
Thanks.