I am using a measure of assigned/in progress in this way
assigned & progress = calculate(count(' ITSM Tickets'[Id]),'ACD ITSM Tickets'[Status]="Assigned" || ' ITSM Tickets'[Status]="In-Progress" || ' ITSM Tickets'[Status]="Pending")
want to get the count with these conditions but the date filter should not affect on the measure.
In the bellow image the red mark is showing the result which I am getting. In the green mark its showing the required result which I am getting by using edit interraction from the format ribbon.
The created and resolved measures should be affected by the date and the assigned/inprogress should not be affected using the date slicer .
Created = if(isblank(count(' ITSM Tickets'[Id])),"0",count(' ITSM Tickets'[Id]))
Resolved = IF(ISBLANK([resolved cust req]),0,[resolved cust req])
I am trying to get created,assigned/inprogress, and resolved in a single visual. For that tried to use except,allexcept functions but it wont work for me.
Hope you understood if not let me know.