Combine Filters in Filter Area

Hello Dear Power BI-Community

Following task to solve:

Let's assume this table (Tasks with a status and a deadline)

I think everybody can relate 😀

The goal is to automatically filter this table based on the following conditions:

Status = End & Deadline more than 3 months ago from today

Expected Result:

Task 4 should disappear because it was done and the deadline is more than 3 months ago

Unfortunately I have not found a way to use this combined filter.

Any ideas?
Thank you very much for your contribution

Cheers and have a good day

qwertzuiop

try this kind of measure and apply it in visual level filter,

Condition = 
VAR _today90 = TODAY()-90
VAR _result = IF(MAX('Table (6)'[Status])="End" && MAX('Table (6)'[Deadline])<_today90,0,1)
RETURN _result

Thanks,

Arul

Forum Discussion