cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Divya904 Member
Member

DAX to derive distinct value

Hi Expert,

 

Please help me to resolve this. I have requirement as given below:

 

Capture101.PNG

what would be the DAX calculation to get the result as shown for 'Order Received'. Orders Received depends on distinct Sales Orders.

 

Thanks.

4 REPLIES 4
Super User
Super User

Re: DAX to derive distinct value

Hi

 

Create a measure with this formula:

 

Order Received = DISTINCTCOUNT(Sales[SalesOrder])

 

Thanks

Raj

Divya904 Member
Member

Re: DAX to derive distinct value

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

Super User
Super User

Re: DAX to derive distinct value

Can you post some sample data for your scenrio?

 

Thanks

Raj

Community Support Team
Community Support Team

Re: DAX to derive distinct value

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())

捕获.PNG 

 

Regards,

Jimmy Tao