Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 colum...
Need Help
Tips and Tricks
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    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.

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

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.