Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone,
I have been struggling with a simple problem. Hopefully I can get help here.
My data is like this:
This is a table visual from the data. I want to have the average value on the Total row to be: 227/920=24.67%, instead of the average value highlighted here.
Thank you!
Solved! Go to Solution.
I think it should work if you don't create the calculated column but create a measure instead and put that in the visual.
The DAX will be very close to the column DAX but using SUM as an aggregation on each field.
It worked perfectly. Thank you 🙂
I think it should work if you don't create the calculated column but create a measure instead and put that in the visual.
The DAX will be very close to the column DAX but using SUM as an aggregation on each field.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
10 | |
10 | |
9 | |
6 |