Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

remove filter not working

I'm currently writing a DAX that will get the percentage between the total and the filtered amount.   This is what I have so far:   Totals = var ABC = '_sp-Total Invoiced to Date - Current Mon...
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

CALCULATE function can not change the value of variables

Anonymous's avatar
Anonymous
Not applicable
5 years ago

wdx223_Daniel 

 

Do you have any suggestions on how can I achieve my goal?

 

Appreciate!

  • jameszhang0805's avatar
    jameszhang0805
    Icon for Resolver IV rankResolver IV
    5 years ago

    Create a measure of ABC instead of variables and try again. Once a measure was calculated and assigned to variables, the value was static, CALCULATE function can not change the value of variables just like Daniel mentioned.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      jameszhang0805 

       

      Still the same behavior. I already created a measure instead of a variable.

       

      Div1 =
      (CALCULATE([ABC], REMOVEFILTERS('_sp-Total Invoiced to Date - Current Month')))