Calculate distinct count occurence

[rsanyoto]

Hi guys,

I have a simply question. i have a table with customers that have created sales in a period of time. My goal is to distinct count  how many of customer created a sales transaction in a period. For examole this customer created two sales transaction in 2020. the column measure calculate now:

Measure = CALCULATE(

DISTINCTCOUNT('Sales'[CustomerKey]),

FILTER(ALL('Sales'),'Sales'[CustomerKey] = EARLIER('Sales'[CustomerKey])))

Its return now 2 as total but i want to only display value 1 as result. any suggestion to change my cuurent measure?

many thanks

[amitchandak]

@rsanyoto , Try a measure like

Measure = CALCULATE(
COUNT('Sales'[CustomerKey]),
FILTER(ALLSELECTED('Sales'),'Sales'[CustomerKey] = MAX('Sales'[CustomerKey])))

[rsanyoto · Accepted solution]

Hi @amitchandak ,

thanks for your quick response... your proposal result in each row a 2 . To return 1 for each row and as Total the solution that i tested is:

CALCULATE(
DISTINCTCOUNT('Sales'[CustomerKey]),
FILTER(ALLSELECTED('Sales'),'Sales'[CustomerKey] = MAX('Sales'[CustomerKey])))