Dynamic totals based on totals of other columns

Anonymous — Tue, 22 Jan 2019 04:47:36 GMT

hello,

I have table report below , I want to grandtotal of CY DOH LBs the same way I am calculating every single row

CY OH lbs/ AvgSaleslast90days.

10200.00/24.44 which are totals for columns CY OH LBs and Avg Sales last 90 days , right now Power BI is doing a simple column total.4368.29

so 10200.00/24.44 = 417.34 and not 4,368.29 which total of all rows in that column, whats the best way to approach this????

Re: Dynamic totals based on totals of other columns

Stachu — Mon, 18 Feb 2019 11:22:35 GMT

what's the syntax for your calculation? are you using measures or calculated columns?

my guess is you need to use measure insetad of calculated column, then something like this should work

DIVIDE(SUM(Table[CY DOH LBs]), [Avg Sales last 90 days])

topic Dynamic totals based on totals of other columns in Developer

Dynamic totals based on totals of other columns

Re: Dynamic totals based on totals of other columns