Forum Discussion
Cumulative % Sum
Hi Team, I struck with below Dax issue, Kindly help me in the cumulative dax mistake. In Power BI I want to Show Cumulative sum for Pareto chart. when i use allselected function it is behaving di...
Table-1(Fact Table)
| 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 |