topic Show blank as 0 in the matrix in DAX Commands and Tips

Show blank as 0 in the matrix

Anonymous — Mon, 03 Jul 2023 13:45:33 GMT

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

Re: Show blank as 0 in the matrix

Jihwan_Kim — Mon, 03 Jul 2023 14:29:24 GMT

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.

Re: Show blank as 0 in the matrix

Greg_Deckler — Mon, 03 Jul 2023 14:32:05 GMT

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.

Re: Show blank as 0 in the matrix

Anonymous — Tue, 04 Jul 2023 09:40:32 GMT

Jihwan_Kim Thank you this worked!

Re: Show blank as 0 in the matrix

Anonymous — Tue, 04 Jul 2023 09:43:14 GMT

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