DAX to derive distinct value

[Divya904]

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.

[v-yuta-msft]

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

[Anonymous]

Hi

Create a measure with this formula:

Order Received = DISTINCTCOUNT(Sales[SalesOrder])

Thanks

Raj

[Divya904]

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

[Anonymous]

Can you post some sample data for your scenrio?

Thanks

Raj