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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Apologies fo rthe poorly worded question.....but how could i use the switch function in DAX??? happy to learn..

    • 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,