Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Martrix Table with % Vlaues

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

 

 

14 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Ashish_Mathur  here you go 

       

      Notification Type FailureSuccess Success %
      order Delivery89292%
      Order Processing446660%
      Order Validation21045368%
      Total26261170%

       

       

      I need the calculation for the Red Font.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous 
    That is a simple % calculation.

    column = sucess/ (success + failure)

     

    Good luck!

    • Anonymous's avatar
      Anonymous
      Not applicable

      Anonymous 

       

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

       

      Its not that simple can you elaborate a bit