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
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

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

 

 

Regards,

Jimmy Tao