Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have this matrix visual and I'm trying to get percent of total orders as the values. So I'm trying to get two columns: [Total orders by customer name] which I have and [Total orders by customer name and delivery status] so I can divide them. I cant manage to get the totals for each delivery status into one column. I want 1033, 1838, 543 and 1182 in one column instead of 4 seperate columns, so i can divide each row by 3510 to get a percent.
Delivery statuses can overlap, an order can be both 'On Time' and 'Both' so just totaling the orders gives me the wrong values for 'On Time' and 'In Full'. The values above totals are correct, not below. In the first total_orders columns 490 should be 1033 and 1295 should be 1838.
How can I put the totals into one column accordingly? Thank you.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |