Custom total value for measure
Hi, I'm trying to get a specific total value, but I'm not sure how can I achieve it. So I've got two variables "Densidade" and "FX Quimicos". The way my deviation formula works, I can get the total for one or the other, depending on which is being filtered on the slicer. The thing is I want the total also when both are being selected, but the total needs to be the sum of the individual values of each variable. Example below: File: https://we.tl/t-i40oiGDkRJ My total for "Densidade" deviation is -1,11%: My total for "FX Quimicos" deviation is -0,11%: My total value of both variables should be -1,11% + (- 0,10%) = -1,21% I have not been able to get that total of the both variables. Tried summarize but still not working. Could you please help me in this? Thank you Best regards, André
