Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi guys,
After being a reader of this community for weeks, I would need some help for this unanswered question.
It's quite simple, but I couldn't find the solution. I would like to get the average as the total of the table of a measure which counts the number of rows.
Here is my data sample
I would like the average next to the red arrow.
My measure are
Solved! Go to Solution.
I found the solution. I needed to add the countrows within my summarize
I found the solution. I needed to add the countrows within my summarize
I am so glad to hear that your problem has been solved . Please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , This average need a level/column/group by. The one used in visual '
Thanks @amitchandak for your fast reply. I tried both, but still, the total is a sum. 😞
What am I doing wrong?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
10 | |
10 | |
10 | |
9 |
User | Count |
---|---|
20 | |
13 | |
12 | |
11 | |
8 |