Forum Discussion
Incorrect Row and Column Totals
Dear All,
May I seek for your advices on how to calculate the correct column and row totals?
In my matrix, the Row and Column Totals are only adding up the Actual Sales. I only have Actual Sales from Jan to Mar till now, Apr thru Dec are only Forecast Sales.
The "Sales" data in my matrix is being calculated by the following Measure:
The "Selected Avg SO (EA)" is equalivalent to the "Avg Monthly SOV" in the following Measure. This "Avg Monthly SOV" is the one I calculated the Forecast Sales as based on the historical actual sales of the previous 6 month.
Would you please kindly help out? Thanks
1 Reply
- lbendlin
Super User
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
