Calculation based on row and column headers

[ArunkumarK]

Hi All,

I have a problem when i am trying to calculate the average based on the rows and column.

E.g I a table Column have months and Rows have Team name and the table filled with values. Now i wants to calculate the average employee joined per team. Average should be displayed in the highlighted column.

Note: Needs only by Dax or Measures

[ArunkumarK]

Hi,

Thanks for replying back to the queries.  I needs to calculate the average by rows instead of grand total. Like in the first row it should be 4.5 instead of 18.

[v-piga-msft]

Hi @ArunkumarK ,

---

E.g I a table Column have months and Rows have Team name and the table filled with values. Now i wants to calculate the average employee joined per team. Average should be displayed in the highlighted column.

---

It seems that you want to calculate the average employee joined per team so it should be 209/6?

And you want to show the average under the grand total ?

If it is, I'm afraid that we cannot achieve that in matrix in power bi currently.

If I misunderstood, please share your desired output so that we could help further on it.

Best Regards,

Cherry