Measure returning wrong result

[beingEniola]

Please, I'm working on this data to measure the impact of hosting paralympics on the host countries. But the measure I created to calculate the medals won before and after hosting are not returning correct results. The grand total in both prehosting and posthosting columns add up to the total medal won. While the prehosting is < hostYear the posthosting is > host year. What could be the problem?

[Anonymous]

Hi @beingEniola ,

When I reviewed posts and I found that this post didn't seem to be solved yet.

If possible, please provide some dummy data and expected result, thanks.

It would be better that you provide us with more details about this issue.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HotChilli]

I don't fully understand the description, however, the measure is not going to return the number you want because the variable 'totalmedal' is being passed in first. Once a variable is assigned it doesn't change value.

I think you want to use the SUM(......) in the calculate line instead of the variable.

--

That might get you what you want or not (but it will be better than the existing)