Forum Discussion
Dax code for Row level security
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...
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
Best Regards