Strange issue with DAX formula and Row Level Security Role

Question

Hello -&nbsp;I have a basic table below.&nbsp; The DAX formula for the measure is a simple COUNTROWS function:Measure =COUNTROWS(Losses)&nbsp;I have a couple of blanks in the table and need those to be replaced with zeroes, so I add +0 to the formula and it works as desired:&nbsp;Measure = COUNTROWS(Losses)+0 &nbsp;However, when I apply a row level security role and view the visual as that role, the undesired blanks return, and the DAX formula has not been changed, it is still&nbsp;Measure = COUNTROWS(Losses)+0&nbsp;&nbsp;This is very strange - I don't understand what's going on here.&nbsp; Thanks very much for your help!&nbsp;&nbsp;&nbsp;

anonymous · Answer

Greg_Deckler&nbsp;Yes that's correct - all of those rows would be filtered out by the NCTR role.&nbsp; Based on your question, it sounds like there is a difference between the way RLS works and the way a regular slicer/filter would work without a RLS role applied, such that:&nbsp;+With an RLS role enabled for 'NCTR', there are no rows/no data to access, so nothing to compute with the COUNTROWS function and therefore no +0 to add, so therefore blank results.&nbsp;+If no RLS role, but instead filtered to 'NCTR' using a slicer/filter, there are still rows available for the formula to 'see' and for the COUNTROWS function to compute and then add +0, so therefore result shows zero. (all of the tables shown in the thread were filtered to 'NCTR' using a slicer)&nbsp;Does that sound like the right way to think about it?&nbsp;Thanks!

greg_deckler · Answer

Anonymous&nbsp;What is your RLS role definition in terms of its DAX formula?

anonymous · Answer

Hi&nbsp;Greg_Deckler&nbsp;,&nbsp;&nbsp;The DAX formula for the role definition is&nbsp;[Level 2] = "NCTR"&nbsp;Every row in the data has a 4 letter organizational acronym with column name "Level 2", so the role definition is just equal to the acronym.&nbsp;&nbsp;Thank you

greg_deckler · Answer

Anonymous&nbsp;So would all of those rows for FY17 Involuntary Losses be filtered out for NCTR role? I'll have to do some mocking up of data unless you can provide a sample in text.

Forum Discussion

Strange issue with DAX formula and Row Level Security Role

4 Replies

Related content

If formula

DAX Formula Help

formula

Strange CLOSINGBALANCE behaviour

Export data strange characters