Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |