Visual filters not working on calculated measure

[Kumar_rohit4]

I was looking to get the last year week numbers to the current year week

I have created one calculated column and one measures named

DWY = GICC_Incident_View[week]*10000+GICC_Incident_View[FiscalYear]

Measure 2 = CALCULATE([CY INC minus LY INC],FILTER(ALL(GICC_Incident_View),GICC_Incident_View[DWY]=MAX(GICC_Incident_View[DWY])-1))

But whenever i filter based on the team the numbers do not chnage.

Do let me know if i can do something to make this work

[amitchandak · Accepted solution]

@Kumar_rohit4 , try allselected in place of all and check

CALCULATE([CY INC minus LY INC],FILTER(allselected (GICC_Incident_View),GICC_Incident_View[DWY]=MAX(GICC_Incident_View[DWY])-1))