Dax max function not working as expected with RLS applied

[Anonymous]

Hello guys I'll try to be as clear as possible to help you to understing my need.
I have this table in my model with theses values 

type_of_concern_LBtype_of_concern_cdlangColonne

LB	cd	lang	dax( calculate max , filter on cd)
Contract	2	en	Contrat
Warranty	1	en	Garantie
Contract	2	nl	Contrat
Garantie	1	nl	Garantie
Contracto	2	es	Contrat
Garantía	1	es	Garantie
Contrat	2	fr	Contrat
Garantie	1	fr	Garantie

The last column is build as following : 

Colonne = CALCULATE(MAX(lb),cd=RELATED(cd))

I was expecting this column to be recalculated when the RLS is applied but I get the following result when I apply the RLS :

LB	cd	lang	dax( calculate max , filter on cd)
Contract	2	en	Contrat
Warranty	1	en	Garantie

To give more context I have a Smart filter pro by okviz in the report and this filter is currently populated with the lb column. The goal is to set a default value to avoid user to select a value in order to get data.
Before to apply the translation in the report there was only the fr value and only 2 value in the filter -> there was no problem because I was able to save the report after selecting a value and it was set.
Now I have more value in this column, I get this weird behavior where the filter can only be preselected for a single language. 

Without RLS I have as many value in the filter as I have in the table. So the filter is only preselected for a single language. For other language nothing is selected when I have the RLS applied. The goal was to use this new column that would get the max in order to only have 2 value in the filter. But unfortunately this is not recalculated when the RLS is applied and I can't get the right value as expected.
That's it !

Feel free to come back to me if needed. I'm waiting for yours suggestions now 🙂

[Anonymous]

I was using SmartfilterPro by OkViz which was receiving distinct values from LB columns which was filter when RLS was applied. I was not able to set a default values for all RLS scenario. I've switched with the new Segment Filter from powerBi then I'm able to use the cd as value and use the lb as label which is selecting the first label as the one to display. It avoid to have more than 1 label per cd when the rls is not applied. I'm now able to set the default selection on this filter for all rls cases.

[MFelix · Accepted solution]

Hi @Anonymous ,

RLS (Row Level Security) does not impact your data results, meaning that the calculated column won't be impacted in the way the calculation is done.

RLS is used to filter out the data for a specific user so when you use the RLS the user will only see the "rows" you allow him to see. and the measures will be calculated accordingly to it.

What do you want to achieve? Can you give a better explanation of the final outcome.