Forum Discussion
Incorrect table column total (PBI)
Anyone has answer about this problem please. I had checked online allover Power BI site and not answer. I'm creating a report with all with all our Assets and Filter by Year and for some reason the...
They are tables with relationships and yet Years come from another table which has a relationship with the main data. Samething happen with department is selected. Total value is not re calculated. No sure where is the formula or Query to edit this. Any thought?
v-micsh-msft
Microsoft Employee
Microsoft EmployeeHi andyben78,
Would you please share about the formula of the Amount column (or a measure) here?
Mostly this is related with the formula of the column/measure that you are trying to show totals with, check the blog below and see if it would help:
Subtotals and Grand Totals That Add Up “Correctly”
In addition, you may also share the data model and the formula here, we will take a look at it and then offer some further suggestions.
Regards