Forum Discussion

ThisIsHalloween's avatar
ThisIsHalloween
Helper I
2 years ago
Solved

Sum Not Updating with Filter

I am subtracting current fiscal year's receipts less previous fiscal year's receipts but the total continues to take the previous year's receipts into account. I want it to sum only what you can see....
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    ThisIsHalloween Once you have the result computed in a variable, you can apply a filter to it. so nothing is happening here, except whatever computed in the variable:

     

    CALCULATE(
            (RCY - RPY), DATESYTD('Date'[Date], "30/6")), ""))
parry2k's avatar
parry2k
Super User
2 years ago

ThisIsHalloween Once you have the result computed in a variable, you can apply a filter to it. so nothing is happening here, except whatever computed in the variable:

 

CALCULATE(
            (RCY - RPY), DATESYTD('Date'[Date], "30/6")), ""))