Forum Discussion

Madhusmita's avatar
Madhusmita
Frequent Visitor
3 years ago
Solved

Total value repeating across rows in Previous year calculation

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])))

 

 

Show and Tell
Tips and Tricks
Tutorial Requests
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    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.

3 Replies

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    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's avatar
      Madhusmita
      Frequent Visitor
      3 years ago

      Thank you so much for your help it worked. 🙂

      • mbn_eagles's avatar
        mbn_eagles
        Regular Visitor
        2 years ago

        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!