Forum Discussion

dte-chris's avatar
dte-chris
Helper I
6 years ago
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'...
Need Help
  • dte-chris's avatar
    dte-chris
    6 years ago

    I've given up on trying to get a measure to work and decided to just count it with an M query.

az38's avatar
az38
Community Champion
6 years ago

Hi dte-chris 

are you sure you want to calculate countrows in 'ThreatOccurrencesInTimeframe' table based on 'DevicesOnline' table columns values? do you have appropriate relationships?

dte-chris's avatar
dte-chris
Helper I
6 years ago

az38 Sorry, maybe I should have written that better. I do have a relationship. What's happening with the +0 is when I do that, the DevicesOnline starts ignoring filtering when I click on a related parent record. With my first query, everything works except rows with zeros are not displayed, and they get filtered when I click on a parent record in the report. With my second query, my DevicesOnline table in the report displays the entire table at all times, not just the ones related to the selected parent.