Need help in DAX

[vashu-123]

Hello All. Below I am attaching a screenshot of the slicer of my report:

In this Slicer, I have selected "closed", "resolved " and "cancelled". so, whenever i select these three options(closed,resolved and cancelled) my below table which contains a column called "Due_Date" must be blank entirely. 

"Due_Date" column is coming from one table "RL" and the above slicer data is coming from another table called as "Status" and the column name is "state". How can i write dax on this such scenario, when I select "closed',"resolved" and "cancelled" the "due_Date" column must be blank entirely? Please help me on this. Any help would be much appreciated. Thanks in Advance!

[v-jialluo-msft · Accepted solution]

Hi  @vashu-123 ,

Please follow these steps:
(1) Create a new column measure

FLAG = 
IF (
    ISFILTERED ( 'Status'[state] ),
    IF (
        "Closed"
            IN VALUES ( 'Status'[state] )
                && "Cancelled"
                    IN VALUES ( 'Status'[state] )
                        && "Resolved" IN VALUES ( 'Status'[state] ),
        0,
        1
    ),
    1
)

(2)Add filtering

(3)Final output

Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vashu-123]

@v-jialluo-msft Thank you so much. It worked in my report.