Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
I have a data looks like below
Its a matrix where calculation is like
(sum of all values of column1 /sum of E)*100
so it has be for each row of account column.
.
i refraim my query
top most view is data and then matrix view.
To conclude.
all sum of rows must be divide by same value gross sales *100
Show your underlaying data structure or table please. Is gross sales a column in your table?
Proud to be a Super User!
gross sales is same as other values as account in that column
Proud to be a Super User!
= DIVIDE(
CALCULATE(sum('table'[column1], REMOVEFILTERS(),
sum('table'[column1])
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 23 | |
| 21 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 58 | |
| 51 | |
| 39 | |
| 29 | |
| 24 |