topic Re: DAX Cumulative Total on percentages that are GROUPED in DAX Commands and Tips

DAX Cumulative Total on percentages that are GROUPED

Anonymous — Fri, 21 May 2021 22:17:39 GMT

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/

Re: DAX Cumulative Total on percentages that are GROUPED

amitchandak — Sat, 22 May 2021 03:02:47 GMT

Anonymous , Try like

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

Re: DAX Cumulative Total on percentages that are GROUPED

Jihwan_Kim — Sat, 22 May 2021 03:05:33 GMT

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

Re: DAX Cumulative Total on percentages that are GROUPED

Anonymous — Tue, 25 May 2021 18:00:45 GMT

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

Take care

Re: DAX Cumulative Total on percentages that are GROUPED

Anonymous — Tue, 25 May 2021 18:02:01 GMT

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