Reply
Highlighted
Community Support Team
Posts: 1,393
Registered: ‎07-30-2018

Re: Number of Services with Incident

hi, @Tenkes77

For point Nr.1: you could try these two measure

Measure 1 = CALCULATE(COUNTA('Incident Report'[ASPStatusID]),FILTER('Incident Report','Incident Report'[ASPStatusID]=1))


Measure 2 = CALCULATE(COUNTA('Incident Report'[ASPStatusID]),FILTER('Incident Report','Incident Report'[ASPStatusID]=2))

For point Nr.2: you could also try these two measure

Measure 3 = CALCULATE(COUNTA('Incident Report'[ASPStatusID]),FILTER('Incident Report','Incident Report'[ASPStatusID]=1))



Measure 4 = CALCULATE(COUNTA('Incident Report'[ASPStatusID]),FILTER('Incident Report','Incident Report'[ASPStatusID]=2))

6.JPG8.JPG

 

IF you want "0" instead of blank value in the visual, you could add "+0" at the end of each formula.

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.