Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
65 | |
64 | |
56 | |
39 | |
27 |
User | Count |
---|---|
85 | |
59 | |
45 | |
43 | |
38 |