Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello everybody!
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!
Solved! Go to Solution.
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).
Apply a FILTER () on top of the CROSSJOIN ().
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.