QTD and YTD values are not showing up at each region when slicer is changed

[raghu_7270]

HI Team,

I have created the below calculation for creating YTD and QTD, the result is correct but in the table the value is not getting show at each regoin level as per the below screen shot, any help to resolve this will be really helpfull...

Rev_CY_QTD_T = Var mm= SELECTEDVALUE( LSS_TEST[POSTING_FISCAL_PERIOD])

var yy= SELECTEDVALUE( LSS_TEST[POSTING_FISCAL_YEAR])

var qq= convert(SELECTEDVALUE( LSS_TEST[POSTING_FISCAL_QTR]),INTEGER)

var result= CALCULATE(sum( LSS_TEST[AMT_USD_MA]),
FILTER(ALL( LSS_TEST), LSS_TEST[SCENARIO]="ACTUAL" &&
LSS_TEST[POSTING_FISCAL_YEAR]=yy && LSS_TEST[ACCOUNT] in {"410000","410001"} &&
LSS_TEST[POSTING_FISCAL_PERIOD]=mm && LSS_TEST[POSTING_FISCAL_QTR]=qq))

return result

[johnt75]

I think you need to replace the ALL with ALLEXCEPT on the DESTINATION_REGION_NAME column

[raghu_7270]

Thanks for the reply JOhn, I have tried it as well still the same issue