Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
@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.