Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Need help in DAX

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's avatar
    v-jialluo-msft
    3 years ago

    Hi  Anonymous ,

     

    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.

2 Replies

  • v-jialluo-msft's avatar
    v-jialluo-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi  Anonymous ,

     

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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