Forum Discussion
AdministratorTotal as an average
Good
I have the following table with its corresponding columns:
the AGV row is the total of each column, that total that appears is the sum of them. Is there a way for the total to be the average of the columns instead of summation?
Greetings.
Hi, Syndicate_Admin
When you have a lot of columns, if you create measures to modify the totals, then as you said, you need to create a lot of measures.
You can try another way where you just need to add an identity column, and then create matrix visual and modify the aggregation of the total in an average way.e.g.
Please refer to the attachment below for details.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
You can switch the grand total
assume you have a measure
if(isinscope(Table[HORA]), [Measure], averageX(values(Table[Hora]), [Measure]) )
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Syndicate_AdminGood then I would have to create a function like the one you indicate for each column of my table,
Price,Variation....
- v-angzheng-msft
Community Support
Hi, Syndicate_Admin
When you have a lot of columns, if you create measures to modify the totals, then as you said, you need to create a lot of measures.
You can try another way where you just need to add an identity column, and then create matrix visual and modify the aggregation of the total in an average way.e.g.
Please refer to the attachment below for details.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
