Forum Discussion
Data grouping for graphical use
Hi Experts How would i you convert the following SQL sytnax The data that produces the bar chart is then grouped by two category groups: =Switch(Parameters!Grouping.Value = "Department", F...
Most people use this:
https://msdn.microsoft.com/en-us/query-bi/dax/dax-function-reference
For the first one it would be something like:
Measure = SWITCH( MAX([Parameters!Grouping.Value]), "Department",MAX([Fields!Department.Value]), "Division",MAX([Fields!Division.Value]), "Location",MAX([Fields!Location.Value]) )But, incredibly difficult to say without sample/example data. And I'm not even sure you want to be using DAX honestly, you might want to use M (Power Query). Just not nearly enough information to know.
What I really need is sample data that can be copied and pasted into an Enter Data query. Doesn't have to be real data or even much of it.
Sample Data
ClientName Division Location Wallmart 9 New York Wallmart 9 London Wallmart 9 Toronto Wallmart 10 New York Wallmart 10 London Wallmart 10 Florida Wallmart 10 DC Wallmart 8 Toronto Wallmart 8 New York Wallmart 8 London Wallmart 7 Florida Wallmart 7 New York Wallmart 7 Texas Wallmart 7 New York Wallmart 7 Toronto Wallmart 6 New York Wallmart 6 California Wallmart 6 London Wallmart Leadership DC Wallmart Leadership New York Wallmart Leadership Florida Wallmart 5 New York Wallmart 5 Texas Wallmart 5 California Wallmart 5 Florida Wallmart 4 California Wallmart 4 Toronto Wallmart 3 California Wallmart 3 Texas