Forum Discussion

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

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
  • v-cherch-msft's avatar
    v-cherch-msft
    8 years ago

    Hi Divya904

     

    You may try to create measure as below:

     

    Order Received =
DISTINCTCOUNT ( Table1[Sales Order] )

     

    Regards,

    Cherie

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Divya904

     

    You may try to create measure as below:

     

    Order Received =
DISTINCTCOUNT ( Table1[Sales Order] )

     

    Regards,

    Cherie