Martrix Table with % Vlaues

[Anildp]

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 ??

[Ashish_Mathur]

Hi,

Share data in a format that can be pasted in MS Excel.

[Anildp]

@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.

[Ashish_Mathur]

Hi,

Is that your raw data or your visual?

[Anildp]

@Ashish_Mathur my visual

[Ashish_Mathur]

Hi,

I need the raw data (not your vsual)

[Anildp]

@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

[Ashish_Mathur]

Hi,

You may dowload the PBI file from here.  I changed some entries in your Original data.

Hope this helps.

[Anildp]

@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 ??

[Ashish_Mathur · Accepted solution]

Hi,

File attached.

[Anildp]

@Ashish_Mathur  thank you so much for the solution.

---

---

[Ashish_Mathur]

You are welcome.

[Anonymous]

@Anildp 
Please share the raw data as well.

[Anonymous]

Hi @Anildp 
That is a simple % calculation.

column = sucess/ (success + failure)

Good luck!

[Anildp]

@Anonymous 

Success & Failure are the lists of values of Column Event Type 

Its not that simple can you elaborate a bit