Forum Discussion

Divya904's avatar
Divya904
Icon for Helper III rankHelper III
8 years ago

DAX to derive distinct value

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi

 

Create a measure with this formula:

 

Order Received = DISTINCTCOUNT(Sales[SalesOrder])

 

Thanks

Raj

  • Divya904's avatar
    Divya904
    Icon for Helper III rankHelper III
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

      Can you post some sample data for your scenrio?

       

      Thanks

      Raj