Forum Discussion
Basic SUM+0 Measure Removes date Filter
I have a table with monthly financials linked to a date table (many-to-one, single direction). I use the Date table in a slicer to filter the table by the month's records I want to see.
When I add this measure, there is no issue: SUM(GMA[Revenue])
HOWEVER, when I add SUM(GMA[Revenue])+0, all records as visible. It's like the date slicer has been removed.
Can someone explain? Thanks.
Normally, the visual output will suppress rows with blanks. When you append "+0", there aren't any more blanks because BLANK() + 0 = 0, so the measure always returns a value and hence the rows don't get suppressed.
1 Reply
Normally, the visual output will suppress rows with blanks. When you append "+0", there aren't any more blanks because BLANK() + 0 = 0, so the measure always returns a value and hence the rows don't get suppressed.