Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
@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.
@devesh_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 2
@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.
User | Count |
---|---|
89 | |
85 | |
66 | |
62 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
82 | |
71 |