Incorrect Totals

[Bryanna]

Hi,

I have the following table  where it is not providing the correct total. This should reflect 125,126. The count of shipment is a distinctcount of my shipment column.

Thanks for the help!

[Bryanna]

that worked! thanks so much!

[eliasayy · Accepted solution]

hello can you please try :

Correct Total = IF(HASONEFILTER(table[Custom 1]),[Your Measure],SUMX(VALUES(table[Custom 1),[Your Measure]))