Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Count and DAX

Hi Guys, I am facing issue counting the below rows where the condition is like: Count number of rows for each group name where Open date <= Date and resolve date is >= Date. So basically the count ...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 
For a calculated column please use

Count =
COUNTROWS (
    FILTER (
        CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[FactTable.Group Name] ) ),
        'Table'[FactTable.Open Date] <= 'Table'[Date]
            && 'Table'[FactTable.Resolve Rate] >= 'Table'[Date]
    )
)

For a measure you can use

Count =
COUNTROWS (
    FILTER (
        'Table',
        'Table'[FactTable.Open Date] <= 'Table'[Date]
            && 'Table'[FactTable.Resolve Rate] >= 'Table'[Date]
    )
)