Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

help on value using var / return

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 :)

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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.