Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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])
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!