cancel
Showing results for
Did you mean:
Regular Visitor

## The totals are inaccurate with Sample data attachted

Hi all,
I am wondering why the total values are inaccurate as shown below.

Kindly pls see the sample data.

Thanks for help

Joyce

1 ACCEPTED SOLUTION

Accepted Solutions
New Contributor

## Re: The totals are inaccurate with Sample data attachted

Hi @JPY ,

If that's the correct number, then you can create this new Calculated Table, which will not have a relationship to either table.

Summary PBIC =
SUMMARIZECOLUMNS(
'Margin PBIC'[Product Family],
"Total Amount",
SUMX(
RELATEDTABLE('Opp PBIC'),
[Amount (converted)]
)
)

Cheers!

Nathan

7 REPLIES 7
New Contributor

## Re: The totals are inaccurate with Sample data attachted

@JPY  - The problem appears to be that there are multiple Product Families associated with the same Ref Number. So, the Grand Total is an accurate representation, and each row is also an accurate representation of the amount associated with each Product Family. You generally want a fact table row to be associated with only one dimension table row.

Cheers!

Nathan

Regular Visitor

## Re: The totals are inaccurate with Sample data attachted

I simply want the total for each product family and removing duplicates may give inaccurate data.

Regards,

Joyce

Regular Visitor

## Re: The totals are inaccurate with Sample data attachted

How to get this number?

Thanks,

Joyce

New Contributor

## Re: The totals are inaccurate with Sample data attachted

Hi @JPY ,

If that's the correct number, then you can create this new Calculated Table, which will not have a relationship to either table.

Summary PBIC =
SUMMARIZECOLUMNS(
'Margin PBIC'[Product Family],
"Total Amount",
SUMX(
RELATEDTABLE('Opp PBIC'),
[Amount (converted)]
)
)

Cheers!

Nathan

Community Support Team

## Re: The totals are inaccurate with Sample data attachted

Hi @JPY ,

Where is the 10.7bn from? As I checked the pbix you shared. I cannot find the logic to get the correct result as you excepted.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

## Re: The totals are inaccurate with Sample data attachted

10.7 billion is the number that I get when I manually added up all the numbers.

Thanks,

Joyce

Regular Visitor

## Re: The totals are inaccurate with Sample data attachted

I have tried the calculated table and it works for me.

Thank you so much.