Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to compare CUSTOMDATA() returning multiple values to an RLS table's numeric column in DAX?

 

I have an table "Department" with a numeric column "ID" used for RLS. And my CUSTOMDATA() returns the following string: "1,2,5". How can I compare the two?

1 Reply

  • Stachu's avatar
    Stachu
    Community Champion
    7 years ago

    this should work for a string

    CONTAINSSTRING(CUSTOMDATA(), 'Department'[ID])