Forum Discussion
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 ??
Hi,
File attached.
14 Replies
- Ashish_Mathur
Super User
Hi,
Share data in a format that can be pasted in MS Excel.
- AnonymousNot applicable
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
Super User
Hi,
Is that your raw data or your visual?
- AnonymousNot applicable
Hi Anonymous
That is a simple % calculation.column = sucess/ (success + failure)
Good luck!
- AnonymousNot applicable
Anonymous
Success & Failure are the lists of values of Column Event Type
Its not that simple can you elaborate a bit