Total value repeating across rows in Previous year calculation

[Madhusmita]

Hi,

I am struggling to calculate the previous year values across the rows. Right now its giving me the Total value which is repeating across rows. I am expecting the values by name  for each row. Please see the screenshot and the calculation below:

Previous Year: 

CALCULATE(SUM(RESULTS[CADRE POINTS]),FILTER(ALL('RESULTS'),[Year]=SELECTEDVALUE(RESULTS[Year])))

[v-jianboli-msft · Accepted solution]

Hi @Madhusmita ，

Please try something like this:

CALCULATE(SUM(RESULTS[CADRE POINTS]),FILTER(ALL('RESULTS'),[Name]=SELECTEDVALUE(RESULTS[Year])&&[Year]=SELECTEDVALUE(RESULTS[Year])))

If this doesn't work, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

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

[Madhusmita]

Thank you so much for your help it worked. 🙂

[mbn_eagles]

Hi @Madhusmita , can you share your final solution? I mean your DAX formula. I'm asking because I didnt understand this part [Name]=SELECTEDVALUE(RESULTS[Year]) in the formula below:

CALCULATE(SUM(RESULTS[CADRE POINTS]),FILTER(ALL('RESULTS'),[Name]=SELECTEDVALUE(RESULTS[Year])&&[Year]=SELECTEDVALUE(RESULTS[Year])))

Thanks!