I would like to create a table in which I can give access to a certain page of a report for a certain user
Imagine I have a table like this:
I have another table in which I have the name of every report page:
I want to get a table in which I have the users and all the pages at which they hace access to depending on their group. Group 1 can see all pages, but group 2 only can see the Team page:
I know how to doing it with R but the "Run R script" option in Power BI doesn't work fine because it always gives me an empty table. I wanto to know how to do it with DAX.
Thanks in advance!
Go to Solution.
Apply a FILTER () on top of the CROSSJOIN ().
View solution in original post
in DAX you do this with CROSSJOIN()
But with CROSSJOIN () function the result is a cartesian product for every email and for every page. The thing is I need the cartesian product for every email but for certain pages (depending what group they belong to).
Click here to read more about the November 2022 updates!
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.