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. 

Bibiano_Geraldo's avatar
Bibiano_Geraldo
Super User
1 year ago

Hi ianboothman ,

If i undertood well, you want to count only unique Sales ord (that appears only one time, with no duplicates), this can be reached by this DAX:

Unique Sales Orders = 
COUNTROWS(
    FILTER(
        SUMMARIZE(
            'Statles2', 
            'Statles2'[Sales Ord], 
            "Count", COUNTROWS('Statles2')
        ), 
        [Count] = 1
    )
)

 

Your result will look like this, because there's only one sales order that appears once: