Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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])
User | Count |
---|---|
98 | |
76 | |
75 | |
49 | |
27 |