Forum Discussion

andyben78's avatar
andyben78
Regular Visitor
9 years ago

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...
Need Help
Evogelpohl's avatar
Evogelpohl
Helper V
9 years ago

Is the table containing FY Report.. (date) connected to the table with the summable amount values?  It appears that it isn't - as it's not even filtering on 2013 data at all.

andyben78's avatar
andyben78
Regular Visitor
9 years ago

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's avatar
    v-micsh-msft
    Microsoft Employee
    9 years ago

    Hi 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