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. 

 

HASONEFILTER was recommended to me but I haven't had luck with that working. 

 

Difference = 

VAR RPY = 

CALCULATE(
    sum(Receipts[Net Amount]),
    PARALLELPERIOD('Date'[Date],-12,month))


VAR RCY = 
    CALCULATE(
        SUM(Receipts[Net Amount]))


RETURN

if(HASONEFILTER('Date'[FY]),
    if(sum(Receipts[Net Amount]) <> 0,
        CALCULATE(
            (RCY - RPY), DATESYTD('Date'[Date], "30/6")), ""))

 

 

 

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")), ""))

1 Reply

  • 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")), ""))