Forum Discussion
Handling Blank in a table
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
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.
1 Reply
v-xuding-msftCommunity Support
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.