Dax code for Row level security

[Anonymous]

I have a cube in SSAS.in the cube i have multiple dimesions and multiple fact tables. I have dim category and dim mco tables are there.I have category column from dim category and MCO column from dim MCO .in the category i have different product values are like "tea,coffe and MCO different values are there like in below i attached so i created a role. in the role i dont want show tea related some of MCO values when user login in service.I want show for tea category- MCO(india,indenosia,nepal countries). Is this possiable to create RLS? Because I dont have realitionship between dim category and dim MCO. In that case what is apporach to achieve this RLS.

Thanks

Ruthwik

[Anonymous]

Hi @Anonymous ,

I don't quite understand your needs, what is the end result you want? Is it that you want to get the list of MCOs corresponding to the selected category or something else? In order to provide you a suitable solution, could you please share some simple sample data (excluding sensitive data), information about the relationship between the fact tables and the dimension tables and your desired result with the backend logic and the actual examples. It would be nice if you could provide a simplified pbix file. Thank you.

In addition, you can refer the following links to get it.

Retrieve a value of a column from another table

DAX: LOOKUPVALUE - Retrieve value of a column from another table in POWER BI

Power BI LOOKUPVALUE

Best Regards