Cumulative % Sum

Question

Hi Team,I struck with below Dax issue, Kindly help me in the cumulative dax mistake.In Power BI I want to Show Cumulative&nbsp; sum for Pareto chart. when i use allselected&nbsp; function it is behaving differently because we have weightage for all filters but we want to consider only Filters which has error count Greater than zero.Cumulative Test = &nbsp;Var Total = CALCULATE([% of Total], ALLSELECTED('MCD Subcat'[Filter 1]))Var _current = [% of Total]Var _SumTable = SUMMARIZE(ALLSELECTED('MCD Subcat'), 'MCD Subcat'[Filter 1],"Errors",[% of Total])Var Cumulativesum = SUMX(FILTER(_SumTable,[% of Total] &gt;= _current),[% of Total])Return&nbsp;DIVIDE( Cumulativesum, Total)% of Total = &nbsp;DIVIDE( [X],&nbsp; &nbsp; CALCULATE(SUMX('MCD Subcat', [Filter 1 count] * 'MCD Subcat'[Weightage]),ALLSELECTED('MCD Subcat'[Filter 1])),0) X = COUNT('MCD Subcat'[Week])* MAX('MCD Subcat'[Weightage])&nbsp;

vinod_g_245 · Answer

Kindly ping here if need additional information

greg_deckler · Answer

Vinod_G_245&nbsp;Is the image what you are getting or what you want to achieve? Can you post sample data?&nbsp;
&nbsp;
Sorry, having trouble following, can you post sample data as text and expected output?Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490The most important parts are:1. Sample data as text, use the table tool in the editing bar2. Expected output from sample data3. Explanation in words of how to get from 1. to 2.

vinod_g_245 · Answer

Table-1(Fact Table)MonthWeekFilter 1JunWeek 3Contact_ResultJunWeek 3Drop_down_BoxesJunWeek 3Dead_AirJunWeek 3Contact_ResultJunWeek 3Disclaimer_DocumentedJunWeek 3Communication_RecordJunWeek 3Disclaimer_DocumentedJunWeek 3Hold_TimeJunWeek 3Communication_RecordJunWeek 3Requesting_ProviderJunWeek 3Authentication_DocumentedJunWeek 3Correct_Complete_AttachmentJunWeek 3Call_Recorded_Statement_DocumentedJunWeek 3Accurate_Complete_InfoJunWeek 3Dead_AirJunWeek 2Requesting_ProviderJunWeek 2Disclaimer_DocumentedJunWeek 2Communication_RecordJunWeek 2Disclaimer_DocumentedJunWeek 2Dead_AirJunWeek 2Call_Recorded_Statement_DocumentedJunWeek 2Dead_AirJunWeek 2Dead_AirJunWeek 2Dead_AirJunWeek 2MemberJunWeek 2Disclaimer_VerballyJunWeek 1Communication_RecordJunWeek 1Drop_down_BoxesJunWeek 1Dead_AirJunWeek 1Disclaimer_DocumentedJunWeek 1Contact_ResultJunWeek 1Courteous_EngagedJunWeek 1Courteous_EngagedJunWeek 1Accurate_Complete_InfoJunWeek 1Disclaimer_DocumentedJunWeek 1Disclaimer_DocumentedJunWeek 1Drop_down_BoxesJunWeek 1Call_Recorded_Statement_DocumentedJunWeek 1Disclaimer_VerballyJunWeek 1Dead_AirJunWeek 1Correct_Complete_AttachmentJunWeek 1Drop_down_BoxesJunWeek 1Disclaimer_VerballyTable-2 (Weight to multiply the error count)Identify_Self3Call_Recorded_Statement_Verbal3Call_Recorded_Statement_Documented3Authentication_Verbal3Authentication_Documented3Notification_of_Determination10Contact_Result5Disclaimer_Verbally5Disclaimer_Documented3Requesting_Provider3Treating_Provider3Facility3Member3Drop_down_boxes3Requested_Authorized_Units3Type_of_Units3Service_First_Last_Day3Notification_Date3Request_Type3DX_Code3CPT_Code3Process_Timely3Expedited5Correct_Filename_Attachment3Correct_Sent_Received_Attachment3Correct_Complete_Attachment5Correct_Fax_Number_sent_entered3Communication_Record5Task3Dead_Air3Hold_Time3Professional_Tone_Language3Courteous_Engaged3Accurate_Complete_Info10Table 3- Error Count Calculation In pivotRow Labels&nbsp;Count of WeekAccurate_Complete_Info2Authentication_Documented1Call_Recorded_Statement_Documented3Communication_Record4Contact_Result3Correct_Complete_Attachment2Courteous_Engaged2Dead_Air8Disclaimer_Documented7Disclaimer_Verbally3Drop_down_Boxes4Hold_Time1Member1Requesting_Provider2Grand Total43

vinod_g_245 · Answer

Hi&nbsp;Greg_Deckler&nbsp;: Thank you for response, By using above data created first Posted table.

vinod_g_245 · Answer

Hi All,Can anyone help me how to get above cumulative % sum by using below two tables.&nbsp; Getting cumulative % on filter is becoming challenge.

Forum Discussion

Cumulative % Sum

5 Replies

Related content

cumulative sum

Cumulative SUM

cumulative sum

Cumulative Total

Cumulative sum

Month	Week	Filter 1
Jun	Week 3	Contact_Result
Jun	Week 3	Drop_down_Boxes
Jun	Week 3	Dead_Air
Jun	Week 3	Contact_Result
Jun	Week 3	Disclaimer_Documented
Jun	Week 3	Communication_Record
Jun	Week 3	Disclaimer_Documented
Jun	Week 3	Hold_Time
Jun	Week 3	Communication_Record
Jun	Week 3	Requesting_Provider
Jun	Week 3	Authentication_Documented
Jun	Week 3	Correct_Complete_Attachment
Jun	Week 3	Call_Recorded_Statement_Documented
Jun	Week 3	Accurate_Complete_Info
Jun	Week 3	Dead_Air
Jun	Week 2	Requesting_Provider
Jun	Week 2	Disclaimer_Documented
Jun	Week 2	Communication_Record
Jun	Week 2	Disclaimer_Documented
Jun	Week 2	Dead_Air
Jun	Week 2	Call_Recorded_Statement_Documented
Jun	Week 2	Dead_Air
Jun	Week 2	Dead_Air
Jun	Week 2	Dead_Air
Jun	Week 2	Member
Jun	Week 2	Disclaimer_Verbally
Jun	Week 1	Communication_Record
Jun	Week 1	Drop_down_Boxes
Jun	Week 1	Dead_Air
Jun	Week 1	Disclaimer_Documented
Jun	Week 1	Contact_Result
Jun	Week 1	Courteous_Engaged
Jun	Week 1	Courteous_Engaged
Jun	Week 1	Accurate_Complete_Info
Jun	Week 1	Disclaimer_Documented
Jun	Week 1	Disclaimer_Documented
Jun	Week 1	Drop_down_Boxes
Jun	Week 1	Call_Recorded_Statement_Documented
Jun	Week 1	Disclaimer_Verbally
Jun	Week 1	Dead_Air
Jun	Week 1	Correct_Complete_Attachment
Jun	Week 1	Drop_down_Boxes
Jun	Week 1	Disclaimer_Verbally

Table-2 (Weight to multiply the error count)
Identify_Self	3
Call_Recorded_Statement_Verbal	3
Call_Recorded_Statement_Documented	3
Authentication_Verbal	3
Authentication_Documented	3
Notification_of_Determination	10
Contact_Result	5
Disclaimer_Verbally	5
Disclaimer_Documented	3
Requesting_Provider	3
Treating_Provider	3
Facility	3
Member	3
Drop_down_boxes	3
Requested_Authorized_Units	3
Type_of_Units	3
Service_First_Last_Day	3
Notification_Date	3
Request_Type	3
DX_Code	3
CPT_Code	3
Process_Timely	3
Expedited	5
Correct_Filename_Attachment	3
Correct_Sent_Received_Attachment	3
Correct_Complete_Attachment	5
Correct_Fax_Number_sent_entered	3
Communication_Record	5
Task	3
Dead_Air	3
Hold_Time	3
Professional_Tone_Language	3
Courteous_Engaged	3
Accurate_Complete_Info	10

Table 3- Error Count Calculation In pivot Row Labels	Count of Week
Accurate_Complete_Info	2
Authentication_Documented	1
Call_Recorded_Statement_Documented	3
Communication_Record	4
Contact_Result	3
Correct_Complete_Attachment	2
Courteous_Engaged	2
Dead_Air	8
Disclaimer_Documented	7
Disclaimer_Verbally	3
Drop_down_Boxes	4
Hold_Time	1
Member	1
Requesting_Provider	2
Grand Total	43