RLS on working on Calculated Column

Question

I found that Row Level Security does not work on calculated colum.

The follwoing is my simple data model.

I have 3 measures defined on Price table:

Retail Low := CALCULATE(MIN(Price[Price]),PriceType[Price_Type_Name]="Retail")

Wholesale Low := CALCULATE(MIN(Price[Price]),PriceType[Price_Type_Name]="Wholesale")

PriceDiffMeasure := [Wholesale Low]-[Retail Low]

A calculated colum is defined on Terminal table:

Ternimal[DiffCalucatedCol] = Price[PriceDiffMeasure]

When no RLS is applied, the PriceDiffMeasure and Ternimal[DiffCalucatedCol] have same value, as I have expected. The following is a screenshot of table showing this:

I created a RLS rule applied to Price table. (Customer_ID=2). However, I see DiffCalucatedCol and PriceDiffMeasure have different values. Compared with table above, value of DiffCalcuatedCol did not change after RLS is applied.

The following is RLS rule setting.

The following is the screenshot of Price table

I have to use Caluclated Column in the terminal table since it will be eventually used as a legend of a Map and measure can't be used as legend on a map. Does anyone know how to apply RLS to calculated column?

The related pbix file can be found here.

d_gosbell · Answer

Anonymous&nbsp;wrote:&nbsp; Does anyone know how to apply RLS to calculated column?&nbsp;You can't do this, calculated columns are calculated once during data refresh over all the data in the model. RLS rules are applied dynamically at run time, so by the time the RLS kicks in the calculated column is already calculated.&nbsp;Do you need to have every distinct difference value in your legend? If not you could use a dynamic segmentation approach to group the different values eg&nbsp;https://www.daxpatterns.com/dynamic-segmentation/&nbsp;into various ranges of differences.

anonymous · Answer

d_gosbell&nbsp; thank you for the repsone.&nbsp; I don't need to show every distince value.&nbsp; The legend of map is categories of price diff range. I have not looked every line of dynamic segmentation, but it seems this methond can generate range measures.&nbsp; However, my problem is that measure CAN'T be used a the legend of map. do you have any suggestions?

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,The available map visuals in Power BI doesn't support measure values in legend section.You can try with other other map custom visuals from&nbsp;https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals. But not sure, these visuals have that feature or not.Thanks,Amit

d_gosbell · Answer

Anonymous&nbsp;wrote:d_gosbell&nbsp; thank you for the repsone.&nbsp; I don't need to show every distince value.&nbsp; The legend of map is categories of price diff range. I have not looked every line of dynamic segmentation, but it seems this methond can generate range measures.&nbsp; However, my problem is that measure CAN'T be used a the legend of map. do you have any suggestions?No it uses a combination of a measure and a segment table. The idea then is to use a COLUMN from the segment table in the Legend. Assuming that you are using either the standard "Map" or "Filled Map" visual where you put the measure in the Color Saturation or Size field wells.&nbsp;If you are using the "Map" visual and you used the data set from the article you would put the Ranges[Price Range] column on the Legend and the [SalesRange] measure on the Size.&nbsp;

Forum Discussion

RLS on working on Calculated Column

4 Replies

Related content

TMDL - calculated column

Direct Lake Model - Calculated Column/Tables

Calculation not working when slicers applied

Power Query or Calculated columns

Dynamic Variable in Calculated Columns