Slicer issue

[jostnachs]

Hi All.... I have a requirement i am struggling with...

I have logic as below as a slicer to divide my activities. 

But the problem is if the activity followupstartdate is 5th feb and today is 16th feb, and if the closed status is not equal to s or u it has to fall under 2 categories.(Open & Due now ,Open & 7+days past due). but as per below screen shot t falls under due now. how do i acheive it? i.e when i select any option between these two below i should be able to see that activity.

Help please!

[Anonymous]

Hi @jostnachs ,
You can try the following code

DueStatus = 
VAR TodayDate = TODAY()
VAR ClosedDate = V_DimActivities[FollowupStartDate]
VAR ClosedStatus = V_DimActivities[ClosedStatus]
VAR DaysDifference = DATEDIFF(ClosedDate,TodayDate,DAY)
RETURN
IF(
    ClosedStatus <> BLANK() && (ClosedStatus = "S" || ClosedStatus = "U"),
    "Closed",
    IF(
        ClosedStatus <> BLANK() && ClosedStatus <> "S" && ClosedStatus <> "U",
        IF(
            DaysDifference > 7,
            "Open & 7+days past due" ,
            IF(
                DaysDifference >= 0,
                "Open & Due now"
            )
        )
    )
)

Turn on multi-select in slicer settings

Final output

Best regards,
Albert He

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

[Wilson_]

jostnachs,

I'm guessing your logic is a calculated column? In any case, one DAX calculation can't return two different values. My first question is why would your slicer criteria not be mutually exclusive? Why would one item fall under multiple statuses?

[jostnachs]

What do you mean by mutually exclusive... sorry i dont get it.

[Wilson_]

jostnachs,

Why would your slicer criteria not be mutually exclusive, meaning I would suggest having slicer options (ex: A, B, and C) where one activity must be either A, B, or C and cannot be more than one of A, B, and C at the same time.

Let me know if I should explain further or differently!

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.