Power BI Card Total (Sum) is not adding up correctly (No filters/slider applied)

[polestar500]

I have the following data. When I generate the matrix summary of the data based on CONCEPT + Sum of AMOUNT, the value that I expect as total (which is 111,093,647.74) matches, but the aggregated card don't.

Here's the matrix summary configuration as reference:

However the card aggregation (not using DAX, only the SUM of AMOUNT + native Power BI filters) show the WRONG value aggregate:

Here's the card aggregate configuration as reference:

Also here's the column type descriptions as reference:

I'm kindly asking for assist as it looks like I'm facing a Power BI bug that seems to be quite sensitive to be happening. Please note that I'm NOT having any filter/slicer applied to the dashboard when these screenshots were taken. Thanks for your assist.

[v-hjannapu]

Hi @polestar500,
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Regards,
Harshitha.

[v-hjannapu · Accepted solution]

Hi @polestar500,

Just checking in to see if you had a chance to follow up on our earlier conversation. If you're still encountering the issue, please share the sample data so we can assist you with an accurate solution.

If you have any further questions, feel free to reach out anytime.

Regards,
Harshitha.

[v-hjannapu]

Hi @polestar500,
Hope everything’s working fine now. If the issue persists, please provide a sample dataset so we can assist you with a solution. Don’t hesitate to reach out if you need further help.

Best Regards,
Hasrhitha.

[HarishKM]

@polestar500  Hey,
you can use below measure

Measure =

Var _M = calculate(sum(table[amount]),table [dataflag] = "Real"))

return
_M

if it is giving your right value then we are on the right track.

Measure 2 =

Var _M = calculate(sum(table[amount]),table [dataflag] = "Real" and amount >0))

return
_M

Thanks

Harish M

Please accepts this as a solution if it is solve your problem and give kudos as well

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[ToddChitt]

Are all fields from the same table?

What happens if you create a MATRIX visual and compare DATA FLAG on one axis and CONCEPT on another, with the SUM at the intersection?