Forum Discussion
dte-chris
Helper I
Helper ICOUNTROWS + 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
Community Champion
Community ChampionPerhaps
device_threats = VAR __Count = COUNTROWS(FILTER('ThreatOccurrencesInTimeframe', CONTAINS('DevicesOnline', [id], 'ThreatOccurrencesInTimeframe'[device_id])))
RETURN
IF(ISBLANK(__Count),0,__Count)
device_threats = VAR __Count = COUNTROWS(FILTER('ThreatOccurrencesInTimeframe', CONTAINS('DevicesOnline', [id], 'ThreatOccurrencesInTimeframe'[device_id])))
RETURN
IF(ISBLANK(__Count),0,__Count)
dte-chrisHelper I
Helper IGreg_Deckler That didn't seem to change anything.
- Greg_DecklerTry clicking on your column in Values area and choose "Show items with no data"?
- dte-chris
Greg_Deckler That does not appear as an option. Also, read the edit to my OP.
- dte-chris
I've given up on trying to get a measure to work and decided to just count it with an M query.