Handling Blank in a table

[Anonymous]

In my Matrix table 

Measure  Name = (Distinctcount(Table[Column] + 0)

I used mention calculation for replaced  0 instead of blanks

when I used this  calculation unwanted columns turns up
so

in my database, I have data up to April 

and I don't want to show the rest of the month 

Any Ideas how can I Sort this??
Thanks in advance 

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

I created a sample that may help you. You could reference it and check if it works in your report.

Measure = IF(MAX('Table 1'[Date]) <> BLANK() && MAX('Table 1'[Values]) = BLANK(), 0 ,SUM('Table 1'[Values]))

I attached my sample that you can download. If it doesn't work, please tell me what the difference between your data model and mine.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.