BryannaHelper II3 years agoSolvedIncorrect TotalsHi, 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! Anonymous3 years agohello can you please try :Correct Total = IF(HASONEFILTER(table[Custom 1]),[Your Measure],SUMX(VALUES(table[Custom 1),[Your Measure]))
Anonymous3 years agohello can you please try :Correct Total = IF(HASONEFILTER(table[Custom 1]),[Your Measure],SUMX(VALUES(table[Custom 1),[Your Measure]))
Anonymous3 years agohello can you please try :Correct Total = IF(HASONEFILTER(table[Custom 1]),[Your Measure],SUMX(VALUES(table[Custom 1),[Your Measure]))
2 RepliesReplies sorted by Most LikedAnonymousNot applicable3 years agohello can you please try :Correct Total = IF(HASONEFILTER(table[Custom 1]),[Your Measure],SUMX(VALUES(table[Custom 1),[Your Measure]))BryannaHelper II3 years agothat worked! thanks so much!
AnonymousNot applicable3 years agohello can you please try :Correct Total = IF(HASONEFILTER(table[Custom 1]),[Your Measure],SUMX(VALUES(table[Custom 1),[Your Measure]))
Related contentIncorrect turnover totalMeasure Total IncorrectMatrix Totals IncorrectIncorrect totalIncorrect Total
