Forum Discussion
Visual showing incorrect total
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!
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/
1 Reply
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/