help on value using var / return

[Anonymous]

I have 2 measures called
1) Sale3mths
2) estimatesale
These 2 measures will change according to the filter applied

is it possible to use var to calculate the % change
estimatesale - Sale3mths * 100 / Sale3mths

Any advice is helpful. Thank you 🙂

[v-yuta-msft]

@Anonymous ,

Generally, you need to convert measure to calculate column using dax you have input:

Percentage =
estimatesale - Sale3mths * 100 / Sale3mths

Community Support Team _ Jimmy Tao

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

[Anonymous]

@v-yuta-msft 
as my 2 measure "estimatesale" & "Sale3mths" changes if a user change the filtering, so it alway return me a blank value or wrong value.

however if the "estimatesale" & "Sale3mths" are used separately on it own, the value are correct, but when used in formula

below, the value are wrong

Percentage =
estimatesale - Sale3mths * 100 / Sale3mths

I dont have the file to share as it contain some confidential info, so just wondering if anyone has encounter it before?

Thank so much.