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 querytop 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?
gross sales is same as other values as account in that column
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.