Forum Discussion
Solved
Alternative to SWITCH ()?
My row level security access table has a one to many relationship with my fact table. In this particular chart, when I filter on one of the roles, it filters the data associated with the measures co...
I ended up brining the role into the fact table since it was a one (access) to many (fact). It works that way but I would think there's a better way. And it is definately the SWITCH function. I tried the table with other elements and it worked fine until I added the metric using SWITCH.
Unfortunately this is already deselected.