Measure to calculate impact in a matrix

[IPGeorgiev]

Hi All 🙂 

I want to put a measure in a matrix which will calculate an impact.

Here a sample file can be downloaded https://drive.google.com/file/d/1YzExY86qCzy4jYpRQwL-KZHqBSs4KbU2/view?usp=sharing 

So basically it will be matrix in Powe BI where Agent name will be as a row, Postive and Negative will be a SUM of all positive or all negative responses for each agent and total responses will also be a sum (a separate column in the raw data). Then the question is how to get the impact formular shown in the excel file replicated in the matrix in power bi?

Many thanks in advance!

Best regards,

Ivan

[Ashish_Mathur]

Hi,

You have posted a pased special Pivot Table there.  Share the actual raw data from where the Pivot Table was built.  Also, i think you have interchanged the Positive and Negative headings.  The % positive column should ideally be Positive/Total.  However, in your file, it is Negative/Total.

Lastly, show the expected result very clearly.

[Jihwan_Kim]

Hi, @IPGeorgiev 

Please check the link down below, which is the sample pbix file that I tried to follow your excel file's formula.

https://www.dropbox.com/s/d9svh8uhsvnfz7x/ipgeorgiev.pbix?dl=0 

All measures are in the sample pbix file.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

[IPGeorgiev]

Hi @Jihwan_Kim ,

thanks a lot for the response!

Strange, but it doesnt seem to work for me - when I add it it doest two things:

Always shows 0.00 as value

And for some reason shows all possible names in the list, although before that I have applied some filters via slicers which should reduce the number of names shown based on time frame , location etc. (additional columns in my raw data).

Not sure why this is happening. Any ideas?

Thanks a bunch in advance!

Best regards,
Ivan