Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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????
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |