Forum Discussion
Total value repeating across rows in Previous year calculation
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.
Community SupportHi 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.
Thank you so much for your help it worked. 🙂
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!
