Convert sql to DAX

[valdis]

Hello team,

I'm new in the world of PowerBI,
Can someone help me convert this SQL req to DAX measure plz?

SELECT*,
(SELECT COUNT(*) FROM EDI_SLS_ORDERS_RESPONSE_REPORT AS os WHERE o.OrderNumber=os.OrderNumber) as [Count]
FROM
EDI_SLS_ORDERS_RESPONSE_REPORT AS o
WHERE
(Date_Upset = (SELECT MAX(Date_Upset) AS Expr1
FROM EDI_SLS_ORDERS_RESPONSE_REPORT AS i
WHERE (o.OrderNumber = OrderNumber)))

Details :
I have a table containing duplicate rows and also in this table a row (order id) have multiple statuses (states : Init, accepted, sent etc..)
What I'm looking for is to get the last occurence row ( basing on the insert date) and I want to add a new row to count all the occurrences of this row(order)
I did this in sql but i need to do it in DAX
Regards
Valdis

[Greg_Deckler]

@valdis Generally better if you just post what you are trying to do and sample data. Not everybody knows SQL. But, you your case, this should either be a COUNTX(FILTER...,...) or CALCULATE(COUNT(...), FILTER(...)).

Also, welcome and if you have not read these posts I recommend them: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.