How to fill empty cells with zeros in a measure?

[Chris123Terr]

I have two measurements. One measure counts people over the age of 50 who have won a medal, and the other counts people under the age of 50 who have won a medal.

My intention is to fill empty values ​​with zeroes. When I try:
"if (table[column] = blank(), 0, table[column])"

The table is enlarged

[sg919]

Post deleted as requested

[PaulDBrown]

@sg919 

If your request is unrelated to the original question in the thread, please start a new thread (and delete the above post). Thank you!

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[PaulDBrown · Accepted solution]

Try:

medals > 50 =

VAR _Calc =  IF(ISBLANK(MAX(Table[Medal])), BLANK(),[Count medals > 50] + 0)

RETURN

IF(ISINSCOPE (Table[Medal]), _Calc, [Count medals > 50)