Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I have a matrix that is groups 'Incidents' by a resolution calculation and priority. I am needing to create another column in the matrix that will sum the cumulative total on the '% of Incidents Resolved'.
I have researched and cannot find a clear resolution.
What I need in a 'new' column is the following:
*What I need
Priority %ofIncidents Resolved *Cumulative Total %
P1 0.16%
P2 0.65% 0.81%
P3 55.32% 56.13%
P4 19.68% 75.81%
P5 24.19% 100.0%
I need this to calculate when 'Priority' is expanded as well.
I can send example file to assist.
tks/
Hi, @Anonymous
Please check the below picture and the sample pbix file's link down below.
I suggest having an index column in order to define the sequence of the Priority. Or, if you already have a date-related column to define the order, you can use that column as well.
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.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
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.
Thanks for response. I ended up using a quick measure and eventually got the results I needed.
Take care
@Anonymous , Try like
calculate(sumx(values(Table[priority]),Table[%ofIncidents Resolved]), filter(Table,Table[priority] <= max(Table[priority])))
Hi and thank you for the response. I ended up utilizing the quick measure to get the results I was looking for. I appreciate your help with this!
Take care
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
37 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
32 | |
28 | |
24 | |
24 |