Forum Discussion
Dax Switch Calculation not working as expected
Hi cruncher
Thank you for the follow-up questions.
Since this has already been implemented using Field Parameters but is not filtering dynamically, I would recommend submitting this scenario as a feature request in the official Power BI Ideas forum.
The Product Team actively reviews suggestions there, and if others in the community upvote it, it may be considered for future updates.
https://ideas.fabric.microsoft.com/
I trust this information proves useful. If it does, kindly “Accept as solution” and give it a 'Kudos' to help others locate it easily.
Thank you.
It isn't working as expected. Measure will only give max values for a Region, Country. Basically, I want to switch within same column to dynamically show Region or Country based on country count. Its kind of drill down within same column according the access. If user has access to Multiple Regions then show region. If one region and multiple countries then country.If one region, one country and multiple states then show state and sales/profit or other measures