cancel
Showing results for
Did you mean:
Member

## DAX to derive distinct value

Hi Expert,

what would be the DAX calculation to get the result as shown for 'Order Received'. Orders Received depends on distinct Sales Orders.

Thanks.

4 REPLIES 4
Super User

## Re: DAX to derive distinct value

Hi

Create a measure with this formula:

`Order Received = DISTINCTCOUNT(Sales[SalesOrder])`

Thanks

Raj

Member

## Re: DAX to derive distinct value

Hi Rajendran,

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

Super User

## Re: DAX to derive distinct value

Can you post some sample data for your scenrio?

Thanks

Raj

Community Support Team

## Re: DAX to derive distinct value

Hi

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