Calculate TOTALMTD depending on year filtered in the report

[pmargari]

Hello all

I need to calculate the TOTALMTD , based on the year the user filter.

I have year as filter, and I want to calculate a measure that will show TOTALMTD depending on the year the user filter.

My measure :

CALCULATE (TOTALMTD(COUNTROWS(Table), Table [DataN], USERELATIONSHIP('Date'[Date], Table [DataN])))

So, if current year, 2023,  is selected works fine , but when I choose 2022 I get always blank  

I have tried several options , dateadd, sameperiodlastyear, PARALLELPERIOD , but I never got the correct number from the previous year.

Any tips help will be very welcome as I can’t solve this alone 
Thanks !

[Anonymous · Accepted solution]

Hi @pmargari ,

Please refer to my pbix file to see if it helps you.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pmargari]

Thanks Community Support ,this is exactly what I need ,thanks a lot for your help !