Attached is management accounts where I am showing actual income and expenditure against either budget or reforecast. As it stands, there is no issue for me to review the information on the Desktop. I have shared the report online and have set some RLS where people assigned to a specific Department will be able to see only the information that relates to their department. Until here, all is fine.
The problem arises when users try to access the report. The information is not displaying and the error basically says that because, both, Actual and forecast data are linked to the Department reference table, it can’t show the information.
When I try to delink the forecast from the department, the error fixes itself but then my totals play weird and they don’t tally.
I would like to know how I can tweak my data model so that I can achieve the same thing and get rid of the double link to the Department.
Management_Accounts.pbix (1.6 MB)