https://community.fabric.microsoft.com/t5/Developer/Help-Modifying-a-Formula-after-adding-RLS/m-p/3299028#M43206 <P>Hello</P><P>&nbsp;</P><P>I recently added RLS security to my Power BI report which resulted in some of my visuals to no longer work. Could anyone take a look and my formula and see what I need to modify?</P><P>&nbsp;</P><DIV><DIV><SPAN>Latest Sales Open Orders = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>'Open Orders'</SPAN><SPAN>[Open Order Amt]</SPAN><SPAN>),</SPAN><SPAN>LASTDATE</SPAN><SPAN>(</SPAN><SPAN>'Measure'</SPAN><SPAN>[Date]</SPAN><SPAN>),</SPAN><SPAN>'Open Orders'</SPAN><SPAN>[Category]</SPAN> <SPAN>IN</SPAN> <SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Brands</SPAN><SPAN>[Brands]</SPAN><SPAN>), </SPAN><SPAN>'Open Orders'</SPAN><SPAN>[Ship State]</SPAN> <SPAN>IN</SPAN> <SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Users</SPAN><SPAN>[State]</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>The error in question I am getting is:</SPAN></DIV><DIV>&nbsp;</DIV><DIV><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="roguetrader87_0-1687489757779.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/932588iE0AF23084B3BC35F/image-size/medium?v=v2&amp;px=400" role="button" title="roguetrader87_0-1687489757779.png" alt="roguetrader87_0-1687489757779.png" /></span><P>&nbsp;</P><P>Why did I not get this error before but am now?</P></DIV><DIV>&nbsp;</DIV></DIV> Fri, 23 Jun 2023 03:11:05 GMT roguetrader87 2023-06-23T03:11:05Z https://community.fabric.microsoft.com/t5/Developer/Help-Modifying-a-Formula-after-adding-RLS/m-p/3299028#M43206 <P>Hello</P><P>&nbsp;</P><P>I recently added RLS security to my Power BI report which resulted in some of my visuals to no longer work. Could anyone take a look and my formula and see what I need to modify?</P><P>&nbsp;</P><DIV><DIV><SPAN>Latest Sales Open Orders = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>'Open Orders'</SPAN><SPAN>[Open Order Amt]</SPAN><SPAN>),</SPAN><SPAN>LASTDATE</SPAN><SPAN>(</SPAN><SPAN>'Measure'</SPAN><SPAN>[Date]</SPAN><SPAN>),</SPAN><SPAN>'Open Orders'</SPAN><SPAN>[Category]</SPAN> <SPAN>IN</SPAN> <SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Brands</SPAN><SPAN>[Brands]</SPAN><SPAN>), </SPAN><SPAN>'Open Orders'</SPAN><SPAN>[Ship State]</SPAN> <SPAN>IN</SPAN> <SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Users</SPAN><SPAN>[State]</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>The error in question I am getting is:</SPAN></DIV><DIV>&nbsp;</DIV><DIV><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="roguetrader87_0-1687489757779.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/932588iE0AF23084B3BC35F/image-size/medium?v=v2&amp;px=400" role="button" title="roguetrader87_0-1687489757779.png" alt="roguetrader87_0-1687489757779.png" /></span><P>&nbsp;</P><P>Why did I not get this error before but am now?</P></DIV><DIV>&nbsp;</DIV></DIV> Fri, 23 Jun 2023 03:11:05 GMT https://community.fabric.microsoft.com/t5/Developer/Help-Modifying-a-Formula-after-adding-RLS/m-p/3299028#M43206 roguetrader87 2023-06-23T03:11:05Z