Zero values don't show (I used +0 trick)

[vojtechsima]

Hello, guys,

I have this super weird, error. I have a matrix and if the value is blank, I wanna show zero, so I added to my measure + 0.

This trick always works but somehow it doesn't right now. It does work for card, not for matrix.

Can someone advice how to fix it? I used completely fresh Power BI Instance and I don'T apply any formatting.

Here's the data:

document|document-page|keyword|Appearance|criticality|url|Page

Joy of cooking	Joy of cooking - pg. 158	egg	2	1	http://www.google.com	158
Joy of cooking	Joy of cooking - pg. 158	beef	1	2	http://www.google.com	158
Joy of cooking	Joy of cooking - pg. 247	pasta	2	2	http://www.google.com	247
French cuisine	French cuisine - pg. 17	egg	3	1	http://www.google.com	17
French cuisine	French cuisine - pg. 55	egg	1	1	http://www.google.com	55
French cuisine	French cuisine - pg. 107	baguette	4	2	http://www.google.com	107
Classic Italian Coooking	Classic Italian Coooking - pg. 123	pesto	2	3	http://www.google.com	123
Classic Italian Coooking	Classic Italian Coooking - pg. 157	pasta	4	2	http://www.google.com	157

[Ahmedx · Accepted solution]

create a directory, and then it will work for you
Dimcriticality = DISTINCT('Table1'[criticality])
https://1drv.ms/u/s!AiUZ0Ws7G26RhiCJ5ynucmFNymxK?e=XZ82cD

[vojtechsima]

@Ahmedx , Indeed,

it does work. That's strange.

Thank you

[HotChilli]

Can we see the data model please and what measure you are using?

[vojtechsima]

Hello, @HotChilli ,

it's just sample data for testing, so one table:

Here's my file.