Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |