topic Re: How to compare CUSTOMDATA() returning multiple values to an RLS table's numeric column in DAX? in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-compare-CUSTOMDATA-returning-multiple-values-to-an-RLS/m-p/767309#M3502 <P>this should work for a string</P><PRE>CONTAINSSTRING(CUSTOMDATA(), 'Department'[ID])</PRE><P>&nbsp;</P> Thu, 15 Aug 2019 08:10:44 GMT Stachu 2019-08-15T08:10:44Z How to compare CUSTOMDATA() returning multiple values to an RLS table's numeric column in DAX? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-compare-CUSTOMDATA-returning-multiple-values-to-an-RLS/m-p/766726#M3486 <DIV class="js-vote-count grid--cell fc-black-500 fs-title grid fd-column ai-center">&nbsp;</DIV><DIV class="post-text"><P>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?</P></DIV> Wed, 14 Aug 2019 16:29:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-compare-CUSTOMDATA-returning-multiple-values-to-an-RLS/m-p/766726#M3486 Anonymous 2019-08-14T16:29:28Z Re: How to compare CUSTOMDATA() returning multiple values to an RLS table's numeric column in DAX? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-compare-CUSTOMDATA-returning-multiple-values-to-an-RLS/m-p/767309#M3502 <P>this should work for a string</P><PRE>CONTAINSSTRING(CUSTOMDATA(), 'Department'[ID])</PRE><P>&nbsp;</P> Thu, 15 Aug 2019 08:10:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-compare-CUSTOMDATA-returning-multiple-values-to-an-RLS/m-p/767309#M3502 Stachu 2019-08-15T08:10:44Z