Help with a calculation.

[Anonymous]

have a table in Power BI called AZB in which there are individual INV_NUM and order numbers with multiples Statuses. I want to count the # statuses in each order and I want to extract orders with more than 2 Statuses and count and count the number of orders. Then I want to divide this number by the total # of orders. 

I have tried using the following calculation but it returns the toal number of orders. 

Count of Status > 2 = CALCULATE(DISTINCTCOUNT(v_000_AZB_COPYINVENTHDR[Order Num]), FILTER(v_000_AZB_COPYINVENTHDR, COUNT(v_000_AZB_COPYINVENTHDR[Status]) > 2))

Please help! 

[edhans]

Can you show your data per the instructions below? An order header table typically has one line per order, so I don't know how any can have more than 1 status.

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

[Anonymous]

The first image is AZB. Each order can have multiple lines and invoices so I dedooped it on order + invoice number first because my client only wants the info on order numbers not the lines. Then I merged it with the Status from the Status Audit log in Power Query which is the second image. 

I made a SharePoint video but I am unable to share it here. @edhans Is there a way I can email it to you?