Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |