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...
az38's avatar
az38
Community Champion
6 years ago

Hi RichBurdick 

try ALLEXCEPT()

Count_By_Classification = 
CALCULATE(COUNTROWS(ObservationTable), ALLEXCEPT(ObservationTable, ObservationTable[CLASSIFICATION_OF_OBSERVATION]) )

then just filter it in visual or with slicer, it depends how do you want your desired result should look like

  • 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)

       

      • RichBurdick's avatar
        RichBurdick
        Helper I
        6 years ago

        az38 , unfortunately that did not work.