Forum Discussion

Bryanna's avatar
Bryanna
Icon for Helper II rankHelper II
3 years ago
Solved

Incorrect Totals

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! ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    hello can you please try :

    Correct Total = IF(HASONEFILTER(table[Custom 1]),[Your Measure],SUMX(VALUES(table[Custom 1),[Your Measure]))
Anonymous's avatar
Anonymous
Not applicable
3 years ago

hello can you please try :

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