Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
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 |
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 |