Forum Discussion
Add together dont work
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?
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
1 Reply
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