Forum Discussion
YTD Case count with multiple statuses (Values)
Hello, I am stuglling with the dax query i am using the following query to calculate the YTD cases with one filter and it is working fine, now the challange is i need to add in this count specifi...
Cases YTD = CALCULATE( COUNT( incidents[incidentid] ),
ALL( incidents[createdon] ),
YEAR( incidents[createdon] ) = YEAR( NOW() ),
incidents[statuscode] IN { 5,6 }
)
Cases YTD = CALCULATE( COUNT( incidents[incidentid] ),
ALL( incidents[createdon] ),
YEAR( incidents[createdon] ) = YEAR( NOW() ),
incidents[statuscode] IN { 5,6 }
)
Thanks it works perfect 🙂