Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Please help to calculate dynamic per row difference

Dear colleagues,

Please help me to understand, how can I calculate the NPS impact before and after including different categories of my table. This must be done for each "Section" so I can add it as a column. I know how to do it manually, but I can't come up with a function 😞

 

For example, I have a simple NPS table with records like this:

I want to calculate the NPS and combine it with each Section to see the overall results. Even though I see that "Quality" is the main pain point, and I would like to understand what positive or negative impact each "Section" has on the overall NPS and I can add it as a column after.

I know how to calculate the impact for the Quality - I can manually exclude it from the view and see the difference. Then, I can divide the difference and calculate the percent of that influence but I would like to have it dynamically calculated so I can build different charts and breakdowns after. I don't know if I need a column or a measure to make it work.


I would really appreciate any ideas. 
Thank you very much and God Bless your hard work!

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    I didn't get the point. Are you want that for example row1 section is quality then calculate quality impact and row2 section is location then calculate location impact?

     

    Best Regards,

    Jay

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello,
      Thank you so much for your reply.
      Yes, it must be a separate column that will show the influence of each "Section" on the Total NPS calculation. 
      For example, Section "Quality" has negative NPS: -25%. With it, the total NPS is 60. Without it 77. So the impact of "Quality" is -28.3%.

      I want to have the same logic for each row like this:

      Maybe the file will be helpful so here it is - PBIX file with data