Data grouping for graphical use

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.