Forum Discussion

Orstenpowers's avatar
Orstenpowers
Icon for Post Patron rankPost Patron
6 years ago

Exclude expressions for defining a role

Dear all,   I would like to define roles, but unfortunately I do not know the needed expression. I do have a column “PLP”, containing several correct entries, but sometimes it is just mentioned “n...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Orstenpowers ,

 

Not very clear.

 

What is the expected output. A table, a column.

 

You can use  the EXCEPT function 

 

https://dax.guide/except/

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

  • Orstenpowers's avatar
    Orstenpowers
    Icon for Post Patron rankPost Patron
    6 years ago

    Hi, I am trying to define/ manage roles

     

     

    I thought of something like

    [PLP] <> "not defined" && [PLP] <> blank

    but this does not work. 

    How do I need to adjust this to work properly? Can you help me?

    • Orstenpowers's avatar
      Orstenpowers
      Icon for Post Patron rankPost Patron
      6 years ago

      I got it on my own. 🙂

       

      [PLP] <> BLANK() &&
      [PLP] <> "not defined"

       

      Thanks for your offered support!