Forum Discussion
SWITCH or CASE in Query for data
I would like the query for the data in my visualization to filter for different values in a field depending on the case specified in a parameter. What is the correct syntax? Something like: l...
Hi Odilon,
You can either sync the slicers or use a Report Level filter. Please refer to the snapshot below.
Best Regards,
Dale
Thank you.
Once concern I have with defining a DAX measure restricted to a subset of data rather than restricting the data with the inititial Query is it seems in the first case I am "bringing" in all the data even though different users will only be using different subsets of the data.
Currently I have 2 reports, one for Region 1 and one for Region 2, associated with initital queries filtering to Region 1 or Region 2 Weather-Stations only.
The plus is users in each region only load data fro the report they need.
The disadvantage is I have to edit both reports every time I make a change.
Thoughts?