Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
hello can you please try :
Correct Total = IF(HASONEFILTER(table[Custom 1]),[Your Measure],SUMX(VALUES(table[Custom 1),[Your Measure]))
that worked! thanks so much!
hello can you please try :
Correct Total = IF(HASONEFILTER(table[Custom 1]),[Your Measure],SUMX(VALUES(table[Custom 1),[Your Measure]))
User | Count |
---|---|
53 | |
22 | |
18 | |
18 | |
13 |
User | Count |
---|---|
89 | |
87 | |
50 | |
34 | |
22 |