Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anildp
Helper II
Helper II

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

 

 

1 ACCEPTED SOLUTION

Hi,

File attached.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

14 REPLIES 14
Ashish_Mathur
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur  here you go 

 

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

 

 

I need the calculation for the Red Font.

Hi,

Is that your raw data or your visual?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur my visual

Hi,

I need the raw data (not your vsual)


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur  & @Anonymous 

 

here you go the sample data 

 

 

Delivery StatusEvent TypeStatus CodecountNotification Date
FailedOrder Created3122211/15/2018 0:00
FailedOrder Created3122112/6/2018 0:00
FailedOrder Created3122112/26/2018 0:00
FailedOrder Created312211/13/2019 0:00
FailedOrder Created312211/21/2019 0:00
FailedOrder Created312211/27/2019 0:00
FailedOrder Delivered5445311/5/2018 0:00
FailedOrder Delivered5445511/6/2018 0:00
FailedOrder Delivered5445611/7/2018 0:00
FailedOrder Delivered5445711/8/2018 0:00
FailedOrder Delivered5445511/9/2018 0:00
FailedOrder Delivered5445211/13/2018 0:00
FailedOrder Delivered5445411/14/2018 0:00
FailedOrder Delivered5445611/15/2018 0:00
FailedOrder Delivered5445611/16/2018 0:00
FailedOrder Delivered5445311/17/2018 0:00
FailedOrder Delivered5445311/20/2018 0:00
FailedOrder Delivered5445211/21/2018 0:00
FailedOrder Delivered54451011/22/2018 0:00
FailedOrder Delivered5445211/24/2018 0:00
FailedOrder Delivered5445211/25/2018 0:00

Hi,

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

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

Hi,

File attached.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur  thank you so much for the solution.



 

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

@Anildp 
Please share the raw data as well.

Anonymous
Not applicable

Hi @Anildp 
That is a simple % calculation.

column = sucess/ (success + failure)

 

Good luck!

@Anonymous 

 

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

 

Its not that simple can you elaborate a bit 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.