Forum Discussion

jostnachs's avatar
jostnachs
Helper IV
1 year ago

Slicer issue

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 t...
Need Help
Wilson_'s avatar
Wilson_
Memorable Member
1 year ago

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's avatar
    jostnachs
    Helper IV
    1 year ago

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

    • Wilson_'s avatar
      Wilson_
      Memorable Member
      1 year ago

      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.