Forum Discussion
Helper IIQuestions on 1) column and 2) table security and 3) grouping/printing totals.
Super UserTrying to make Power BI work like another system is called "fighting the API". Embrace the difference.
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with.
Helper III can use my example above of the dept group section.
I have a table that has a name, the levels they have access to
Jane Doe Dept 1 Group 1 Section 1
John Doe Dept 1 Group 1 Section 1
John Wayne Dept 2 Group 2 Section 1
Jane Wayne Dept 2 Group 2 Section 2
Joe Blow Dept 1 Group 1 Section 1
Joe Blow Dept 2 Group 2 Section 1
Joe Blow Dept 2 Group 2 Section 2
What I want to be able to do is to have my current report displaying the totals only available to the person who is running the report.
So if Jane Doe or John Doe logs in, they should only see the report having
Dept 1, Group 1, Section 1 totals, which is 36.
John Wayne logs in and should only be able to see Dept 2, Group 2, Section 1 totals which is 10
Jane Wayne logs in and should only be able to see Dept 2, Group 2, Section 2 totals which is 10
Joe Blow has access to everything and should see all totals: 36, 10 and 10.