Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Expert,
Please help me to resolve this. I have requirement as given below:
what would be the DAX calculation to get the result as shown for 'Order Received'. Orders Received depends on distinct Sales Orders.
Thanks.
Hi Divya904,
Create a calculate column using DAX below:
Result = IF(CALCULATE(COUNT(Table1[Sales Order]), ALLEXCEPT(Table1, Table1[Sales Order])) = 1, Table1[Sales Document], BLANK())
Regards,
Jimmy Tao
Hi
Create a measure with this formula:
Order Received = DISTINCTCOUNT(Sales[SalesOrder])
Thanks
Raj
Hi Rajendran,
Thanks for your reply. It is bit tricky here.
I have fields - Number of Sales documents , Sales Order.
I need to create following logic in DAX.
Result = Number of sales documents where Sales Order is disctinct.
Your help is appreciated here. Thanks
Can you post some sample data for your scenrio?
Thanks
Raj
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |