order number count

[geam1988]

Sales:

LOAD [Order Number],

     Product,

     Year

FROM

test.xlsx

(ooxml, embedded labels, table is Sheet1);

i want to see how many Order Number is there .

i am using Count (Order Number) in expressions it shows 5 . actually i want to see the result as 3 because 100 is 3 times with different product.   what should i do ?

[Anonymous]

Hi,

try using DISTINCT inside your Count function to count only distinct values. In this example: Count (Distinct [Order Number])

[vishsaggi · Accepted solution]

Did you try:

= Count(DISTINCT [Order Number])

[geam1988]

Thanks