Visual showing incorrect total

[Anonymous]

Hi Experts, 

Kindly suggest what am i missing here because the visual actual totals up to 25 however keeps on showing 36.

And when i apply filter "greater than equal to" 1 filter (in green on right) to avoid 0's, the calculation shows up correctly as 25 in blue below. However, than it mismatches with the top left visual (highlighted) in orange- where it should match with 36.

Please advise!

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

I am not sure about how your measure looks like, but please try to write one more measure like below and put it into your visualization.

New measure =
SUMX ( VALUES ( [your client name column] ), [your travellers measure] )

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/