Forum Discussion
Solved
Need Group average at Row level in Table/Matrix
Hi, We are building a sales comparision report across the terrority by salesperson. We need the group average sales to be availalbe at each row, so what we can compare individual salesperson perf...
Can you try this:
Grp Avg = CALCULATE ( AVERAGEX ( VALUES ( Table[Salesman] ), [Amount] ), ALL ( Table[Salesman] ) )Difference = [Amount] - [Grp Avg]
Hi Ankur
Add this two measures two your table:
Average_Total = CALCULATE(AVERAGE(Sales[Amount]),ALLSELECTED(Sales))
Average difference = SUM(Sales[Amount])-[Average_Total]
Then add them to your visual.
Regards,
MFelix
Add this two measures two your table:
Average_Total = CALCULATE(AVERAGE(Sales[Amount]),ALLSELECTED(Sales))
Average difference = SUM(Sales[Amount])-[Average_Total]
Then add them to your visual.
Regards,
MFelix
