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.
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
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.
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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |