Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks for the reply...

 

Let me get some sample data to you. with a better example and explanation. Much Appreicated,