Forum Discussion

RichBurdick's avatar
RichBurdick
Helper I
6 years ago

Performing Counts

I am trying to get counts for a visualization.  I have audit data in the AuditTable and observation data in the ObservationTable and I am trying to get a count of Critical, Major and Minor observatio...
RichBurdick's avatar
RichBurdick
Helper I
6 years ago

Hi az38 

 

For my visualization I need to have a column for Critical, Major and Minor in my table.

az38's avatar
az38
Community Champion
6 years ago

RichBurdick 

maybe it will be enough to set inactive parameter "Show items with no data" in visual settings?

for 0 in empty cell use statement like

Critical = 
var _count = CALCULATE(COUNT(ObservationTable[CLASSIFICATION_OF_OBSERVATION]),FILTER(ALL(ObservationTable), ObservationTable[CLASSIFICATION_OF_OBSERVATION] = "Critical"))
return
if(_count > 0, _count, 0)