Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have a unique issue,
I have a Matrix Table
Event Type = Values ( Failure , Success)
Notification Type = Values ( Order Delivered, Order Processing, Order Validation)
Date = there is a Notification Date ( which is used as a filter)
Count are the values as shown below
Failure Success Success %
Order Delivery 5 95 ??????
Order Processing 12 88 ????
Order Validation 10 90 ????
Total : 27 213 ?????
How do I calculate this Success % only in this Matrix Component?
Can someone please help me with the DAX Formulae ??
Solved! Go to Solution.
Hi,
File attached.
Hi,
Share data in a format that can be pasted in MS Excel.
@Ashish_Mathur here you go
Notification Type | Failure | Success | Success % |
order Delivery | 8 | 92 | 92% |
Order Processing | 44 | 66 | 60% |
Order Validation | 210 | 453 | 68% |
Total | 262 | 611 | 70% |
I need the calculation for the Red Font.
Hi,
Is that your raw data or your visual?
Hi,
I need the raw data (not your vsual)
@Ashish_Mathur & @Anonymous
here you go the sample data
Delivery Status | Event Type | Status Code | count | Notification Date |
Failed | Order Created | 3122 | 2 | 11/15/2018 0:00 |
Failed | Order Created | 3122 | 1 | 12/6/2018 0:00 |
Failed | Order Created | 3122 | 1 | 12/26/2018 0:00 |
Failed | Order Created | 3122 | 1 | 1/13/2019 0:00 |
Failed | Order Created | 3122 | 1 | 1/21/2019 0:00 |
Failed | Order Created | 3122 | 1 | 1/27/2019 0:00 |
Failed | Order Delivered | 5445 | 3 | 11/5/2018 0:00 |
Failed | Order Delivered | 5445 | 5 | 11/6/2018 0:00 |
Failed | Order Delivered | 5445 | 6 | 11/7/2018 0:00 |
Failed | Order Delivered | 5445 | 7 | 11/8/2018 0:00 |
Failed | Order Delivered | 5445 | 5 | 11/9/2018 0:00 |
Failed | Order Delivered | 5445 | 2 | 11/13/2018 0:00 |
Failed | Order Delivered | 5445 | 4 | 11/14/2018 0:00 |
Failed | Order Delivered | 5445 | 6 | 11/15/2018 0:00 |
Failed | Order Delivered | 5445 | 6 | 11/16/2018 0:00 |
Failed | Order Delivered | 5445 | 3 | 11/17/2018 0:00 |
Failed | Order Delivered | 5445 | 3 | 11/20/2018 0:00 |
Failed | Order Delivered | 5445 | 2 | 11/21/2018 0:00 |
Failed | Order Delivered | 5445 | 10 | 11/22/2018 0:00 |
Failed | Order Delivered | 5445 | 2 | 11/24/2018 0:00 |
Failed | Order Delivered | 5445 | 2 | 11/25/2018 0:00 |
Hi,
You may dowload the PBI file from here. I changed some entries in your Original data.
Hope this helps.
@Ashish_Mathur thanks for the solution, unfortunately the one drive is not opening and I can't download it ,
is there any other means you can attach the PBIX ??
You are welcome.
@Anonymous
Success & Failure are the lists of values of Column Event Type
Its not that simple can you elaborate a bit