I want last year values based on filter selection .

[SAPpowerbi]

Hi,

I need values of last year based on below Measure 1 Dax,   so i am using same period last year function

And  I used  TOP- 20 filter on visual level filter on measure 2 then values showing incorrect for last year .

Measure 1 = CALCULATE(Sumx(summarize('Combined_Revenue','Combined_Revenue'[Client],"_1",[SL-1  Combined V4]),[_1]),DATESYTD('Calendar'[Date]))

Measure 2 = CALCULATE([Measure 1],SAMEPERIODLASTYEAR('Calendar'[Date]))

Measure 2 is working fine without Visual level filter for Top 20 values .once i used Top-20 filter then values showing incorrect for last year .

Please help me for the same .

Thank you 

[v-yanjiang-msft]

Hi @SAPpowerbi ,

Could you please provide a simply sample to help reproduce the problem?

Best regards,

Community Support Team_yanjiang