Hello @Helios,
The reason why second formula is giving inflated results is because it is first considering the sum of each and every individual row level as per “VAR X” i.e., “COLD CALL = 256.90” and “EMAIL = 1,047.90” and then when you added the another condition i.e., “VAR FINAL”, it just summed up the results by 2x.
So since previously you had the wrong total as “1,304.80”, now because of that additional variable which you added inside the same formula it inflated the results.
It doesn’t makes sense to add that additional condition inside the same measure where you’re already getting the wrong results at a total level.
If it would have given me the right results by following that technique, then I would have performed that action in the first instance itself rather than creating additional measure for fixing the totals.
If you want to furthermore understand, why you’re getting wrong totals at the first instance then I’ve already provided my solutions onto the forum explaining the reason behind that and those scenario’s are also applicable in your case as well. Below are the links of those posts provided for the references.
Unless and until one has developed very strong understanding of the virtual calculations, it’s better to solve this type of problems by creating additional small measures also known as “Measure Branching Technique” like it has been showcased in the post “How to Fix Incorrect Totals” by our expert. Because when the calculations happen virtually, the error tracing becomes difficult like you faced in this scenario.
Thanks and Warm Regards,
Harsh