Show Average in Grant Total

[PBI_LuckyLuke]

Hi team,

I have a table below and I would like to show the average at the grant total level (the last column). Any suggestion please. Thanks

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	TOTAL	Average
Sale	100	200	300	400	500	600	700	800	900	1000	1100	1200	7800	650
Cost	40	60	80	100	120	140	160	180	200	220	240	260	1800	150
Net	60	140	220	300	380	460	540	620	700	780	860	940	6000	500

Regards,

Luke

[Anonymous · Accepted solution]

Hi @PBI_LuckyLuke ,

Thanks to @FreemanZ  for the valuable input. I will provide more details to get the expected results. I took the following steps:

1.Unpivot the column of the data provided:

2.Create measures:

average = CALCULATE(AVERAGE('Table'[Grant]),ALLEXCEPT('Table','Table'[Type]))

3.The final result is as follows:

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[FreemanZ]

hi @PBI_LuckyLuke ,

the key is to unpivot your table first, then everything will become more intiuitive. 

about unpivot:

https://learn.microsoft.com/en-us/power-query/unpivot-column