DAX Switch criteria activating different table views / filters
hope I am doing it right as this is my first question here ever.
I am currently working on a management dashboard for senior management who are quite old and new to all BI related topics. Thus they need very simple ways to get their information and my boss said that I should not use or let them use multiple filterts by themselves.
What is my problem now?
I have a table with sales data and I want to create some kind of switch (single selection) where they can either choose one or another option. This would be easy when it would rever the same underlying table (such as product 1 or product 2), but I need to create a switch to either show product 1 or department 2. Thereby the related criteria are in different star schema tables.
Until now I was not able to create such a DAX formula that can either select product 1 or department 2 and be used as a filter. Usually I would create a simple mapping table which helps me and can be used as a filter, but I work with a live connection to a DWH where I am not able to create new tables in (no writing access to the data base) thus I need a "in power bi desktop" solution as a DAX code to solve the problem. Hope this is not too confusing.
An alternative would be to create 2 filters and say you are either one or another but not both at the same time or not nothing.