Forum Discussion
Multiple Columns as Rows with Multiple Calculations of those Columns
I have some data in columns as seen below: I need this data to appear in a visual like this: I can't figure out how to make the column headers as rows and then get multiple values fr...
amitchandak
Super User
Super UserIBrant , You need to create calculation groups, you have option in model view to create calculation groups
Create three calculation items and use measures for each of columns. use the Expression function to use data from the line level
Avg = AVERAGEX(Table,SELECTEDMEASURE())
Count = COUNTX(Table,SELECTEDMEASURE())
Sum = Sumx(Table,SELECTEDMEASURE())
I used these two measure and test
Qty Line = Sum(Sales[Qty])
Gross Line = sum(Sales[Gross Sales])
Model explorer public preview with calculation group authoring| Measure Slicer: https://youtu.be/VfxfJJ0RzvU
This sounds great, but I don't have a calculation group option.