Forum Discussion
RLS on working on Calculated Column
Anonymous wrote:Does anyone know how to apply RLS to calculated column?
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.
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 https://www.daxpatterns.com/dynamic-segmentation/ into various ranges of differences.
d_gosbell thank you for the repsone. I don't need to show every distince value. 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. However, my problem is that measure CAN'T be used a the legend of map. do you have any suggestions?
Hi Anonymous ,
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 https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals. But not sure, these visuals have that feature or not.
Thanks,
Amit
Anonymous wrote:d_gosbell thank you for the repsone. I don't need to show every distince value. 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. 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.
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.