Add together dont work

[Pikachu-Power]

hi all,

i have a sum formula like:

CALCULATE(DISTINCTCOUNT(CLIENT[PK]), FILTER(ALL(Calender), Calender[Date] <= MAX(Calender[Date]))

But something seems to be still strange:

DISTINCTCOUNT is 5 but in some cases the formula adds only 4. Sometimes it is right. Sometimes not.

Where can be the mistake?

[az38 · Accepted solution]

@Pikachu-Power 

it is correct.

if you have 5 distinct values Wednesday, it diesn't mean that it is new distinct 5 value as you values could repeated in the last period

for example, below A will be counted as DISTINCT for Tuesday and Wednesday separately, but it will be counted as 1 DISTINCT value for Tuesday + Wednesday

Tuesday	A
Tuesday	B
Wednesday	A
Wednesday	C
Wednesday	D