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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: DAX to derive distinct value

Hi @Divya904

 

You may try to create measure as below:

 

Order Received =
DISTINCTCOUNT ( Table1[Sales Order] )

1.png

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: DAX to derive distinct value

Hi @Divya904

 

You may try to create measure as below:

 

Order Received =
DISTINCTCOUNT ( Table1[Sales Order] )

1.png

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.