Unexpected totals in columns, whilst others are showing expected results.

[Breen]

Hello,

I am replicating a Tableau dashboard within PowerBI. I have a column visual where only some of the columns are returning expected totals. Column '2023' is inaccurate in PowerBI, whilst all the other columns are accurate. 2023 is the outlier:

Figure 1: The Tableau I'm replicating. As you can see, the total is 972.

Figure 2: The Powerbi replication. As you can see, the total is 912.

This error is only happening to 2023. Some totals are higher and lowers than what is expected. 

Points achieved (coloured Legend)	2023 Tableau Totals (what I expect)	2023 PowerBI Totals (what I'm getting)
13	883	843
14	972	912
15	833	774
16	601	555
17	371	353

Figure 3: Comparison Table

I've confirmed that the data source is up-to-date, and calculations must be right because other columns are accurate.

Does any know what causes this issue and how to fix it please?

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...