Countx returns unexpected result

Question

Hi ,I want to count No. of customers who occurred once and more than 1 once.First I have a calculated column :&nbsp;Order occurrence&nbsp;= COUNTX(FILTER('Unique Order customer',EARLIER('Unique Order customer'[Customer No.])='Unique Order customer'[Customer No.]) ,'Unique Order customer'[Customer No.])&nbsp;For the occurrence&nbsp;=1,&nbsp;First Time Buyers = COUNTX(FILTER('Unique Order customer','Unique Order customer'[Order occurance]=1),'Unique Order customer'[Customer No.])and this gives me the correct result.&nbsp;However, when I switch to more than 1, the result is not what I want.Returning Customers = COUNTX(FILTER('Unique Order customer','Unique Order customer'[Order occurance] &gt;1),'Unique Order customer'[Customer No.])&nbsp;as in the card visual, it shows 30, but it is actually only 8 customers&nbsp;

brigittagemes · Accepted Answer

Hi&nbsp;dgdgdg122db ,&nbsp;try DISTINCTCOUNT&nbsp;https://docs.microsoft.com/en-us/dax/distinctcount-function-dax&nbsp;use it in a measure.&nbsp;Yours sincerely,&nbsp;Brigi

Forum Discussion

Countx returns unexpected result

2 Replies

Related content

Gateway installation error - Network request returned unexpected errors

Distinct CountX?

Distinct countx?

COUNTX returning BLANK in total

Dax Countx