DAX Cumulative Total on percentages that are GROUPED

[Anonymous]

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/

[Jihwan_Kim]

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.

Cumulate Percentage =

IF (

SELECTEDVALUE ( 'Table'[Priority] ) = "P1",

BLANK (),

SUMX (

FILTER ( ALL ( 'Table' ), 'Table'[Index] <= MAX ( 'Table'[Index] ) ),

[Incidents resolved percent]

)

)

https://www.dropbox.com/s/x9p4nbs8ucw8xmq/cs556.pbix?dl=0 

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

[Anonymous]

Thanks for response.  I ended up using a quick measure and eventually got the results I needed.

Take care

[amitchandak]

@Anonymous ,  Try like

calculate(sumx(values(Table[priority]),Table[%ofIncidents Resolved]), filter(Table,Table[priority] <= max(Table[priority])))

[Anonymous]

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