Forum Discussion
Solved
COUNTROWS + FILTER and include zero values
I am trying to use a filtered row count, but it's not displaying rows resulting in zero rows counted. Here is my measure formula: device_threats = COUNTROWS(FILTER('ThreatOccurrencesInTimeframe'...
I've given up on trying to get a measure to work and decided to just count it with an M query.
Greg_Deckler That didn't seem to change anything.
Try clicking on your column in Values area and choose "Show items with no data"?
Greg_Deckler That does not appear as an option. Also, read the edit to my OP.
I've given up on trying to get a measure to work and decided to just count it with an M query.