Forum Discussion

tinker's avatar
tinker
Regular Visitor
7 years ago
Solved

DAX - Countrows Filter where rows not exist

have 2 dimension tables joined to CardUser fact table which stores Clock in/out records of each user. The following measure counts the dates where CardUser also contains a row with the same dates...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

tinker 

 

Try this MEASURE

 

Measure 2 =
COUNTROWS (
    EXCEPT (
        VALUES ( Dates[Date] ),
        CALCULATETABLE (
            VALUES ( Dates ),
            CROSSFILTER ( CardUser[CheckIn_DateFormat], Dates[Date], BOTH )
        )
    )
)