Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Countrows not returning correct numbers

I have 2 tables DImDate and CC Starters and Leavers both connected via 1-n relationship see below. When I try to create a measure using countrows it then returns incorrect result for APR-22 and May-2...
Need Help
Show and Tell
Ahmedx's avatar
Ahmedx
Super User
2 years ago

pls try this

Total Leavers Count = 
CALCULATE(
 COUNTROWS(
    'CC Starters & Leavers_26_09_23'),
    REMOVEFILTERS(),
     VALUES('DW DimDate'[FirstDayOfMonth])
    ))