I am using a table visual in which 3 DAX measures are there and a category column to filter out it. form those 2 are simple they are count measures and filter by date and the third is also count but has conditions to filter and the main thing is date should not be affected on it. Can I get some guidance on it? I tried to use except function but it's not working for me. sharing the visual model and the relation in the table.
want to stop the filter of assigned & progress measure. I am using a special date table which has dates in the period column to filter in the periods which relate to date table and further date table relates to
HI, 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]))