Forum Discussion
Helper IIAverage in a table visualisation instead of Total, Possible?
Hi,
It's an simple question. IS that possible to have a average values of all rows in table as shown in image of table visualisation instead of total values of rows?
If yes, let me know with sample data of your choiceand how?
Thanks in advance.
PravalikaT
The8 Yes, it is possible to show the average values of all rows in a table instead of the total values of rows.
Solution1: In Power BI, you can right-click on your value fields and choose the aggregate mode ‘average’.
Solution2: If you don't want to see average at the row level and only want to see average at the total level then you can achieve this by using ISINSCOPE. You can follow this tutorial for the same, it'll defiitely help you: https://youtu.be/smhIPw3OkKA?feature=shared
If you find this insightful, please provide a Kudo and accept this as a solution.
2 Replies
devesh_guptaImpactful Individual
The8 Yes, it is possible to show the average values of all rows in a table instead of the total values of rows.
Solution1: In Power BI, you can right-click on your value fields and choose the aggregate mode ‘average’.
Solution2: If you don't want to see average at the row level and only want to see average at the total level then you can achieve this by using ISINSCOPE. You can follow this tutorial for the same, it'll defiitely help you: https://youtu.be/smhIPw3OkKA?feature=shared
If you find this insightful, please provide a Kudo and accept this as a solution.
The8devesh_gupta I am intrested with your Solution 2, the video which shows me a table with Avg. at total by creating a measure.
In this measure in video we have formula where we use column names(Brand) and as well measure (net). I have taken inputs from video and generated a measure where we use column names of my table.
For example
Table name: Column Total by Avg.
Columns
Level, Value 1 , Value 2Row value 1 Avg. =IF (ISINSCOPE('Column Total by Avg'[Level]),SUM('Column Total by Avg'[Value 1]),AVERAGEX(VALUES('Column Total by Avg'[Level]), CALCULATE(SUM('Column Total by Avg'[Value 1]))))
Thanks devesh_gupta