Measure to ignore specific slicer

[icdns]

Hi Guys,

I wanted to have a dax (count of OVERDUE tickets) that I can use as a measure in a matrix table visual. 

This measure has no dependency, meaning no filters. The only filter of it is OVERDUE tickets. 

However, in my dashboard I have this filter = Created Date. 

How can I build a measure wherein it can ignore the filter = Created Date? 

This is my dax: 

justified_result_OpenOverdue = CALCULATE(COUNT(raw_task[Task No]), FILTER(raw_task, raw_task[Justified Result] = "OPEN:Overdue"),all(raw_task[Completed Date]))

Hope you can help me guys. Thanks! 🙂 

Regards,

aysee

[Mariusz]

Hi @icdns 

Try the below

justified_result_OpenOverdue = 
CALCULATE(
    COUNTROWS( raw_task ), 
    KEEPFILTERS( raw_task[Justified Result] = "OPENSmiley Surprisedverdue" ),
    ALL( raw_task[Completed Date], raw_task[Created Date] )
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[icdns]

Hi @Mariusz , 

I am currently using a matrix table that I can drill down to Service Area > Analyst 

Scenario 1: If complete_date filter is present in the dashboard.. The matrix table doesn't show correct matrix values.

Service Area > Analyst

Scenario 2: If completed_date filter is removed, it shows the correct value in the matrix table 

The dax that you have sent is correct, but why it is not showing the correct values in the matrix table when completed date filter is present 😞