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 on distinct Sales Orders.

 

Thanks.

Need Help

4 Replies

  • 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