I am having an issue where I don’t know where to start if I am honest.

I have a list of projects with their associated budgets, sales etc. which need to be viewed by multiple departments.

It’s essentially like

Project A needs to be seen by Departments 1,2 and 4

Project B needs to be seen by departments 1,2 and 3

Project C needs to be seen by 3 and 4.

And so on.

I can do it through calculated boolean columns to determine if each project is needed by department 1, another for 2 etc. And then using many many measures for each calculated column and a switch measure bases on a selected value in another measure to bring it all together but I can’t help think there might be an easier way.

Hopefully that made sense but any help would be appreciated?