Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper III

## Measure to calculate impact in a matrix

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

3 REPLIES 3
Super User

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Super User

Hi, @IPGeorgiev

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

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.

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

Go to My LinkedIn Page

Helper III

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

## Helpful resources

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors