Forum Discussion

ianboothman's avatar
ianboothman
Frequent Visitor
1 year ago
Solved

Distinctcount

Good Evening    I have a table relating to sales and I would like to find the voulme of unqiue sales orders.   My current DAX  unique order number =DISTINCTCOUNT(Statles2[Sales Ord]) is giving...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    1 year ago

    ianboothman Can you elaborate on why you feel the number you are getting is incorrect? That should give you a distinct count of Sales Ord. You could try replacing that with this code:

    Measure = COUNTROWS( DISTINCT( SELECTCOLUMNS( 'Table', "__SalesOrd", [Sales Ord] ) ) )

    But, again, both DISTINCTCOUNT and that measure should return the same number. 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
1 year ago

ianboothman Can you elaborate on why you feel the number you are getting is incorrect? That should give you a distinct count of Sales Ord. You could try replacing that with this code:

Measure = COUNTROWS( DISTINCT( SELECTCOLUMNS( 'Table', "__SalesOrd", [Sales Ord] ) ) )

But, again, both DISTINCTCOUNT and that measure should return the same number.