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...
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')))