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 ...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

I have created a simple sample, please refer to it to see if it helps you.

Create measures.

Measure =
CALCULATE (
    COUNT('Table'[date]),
    FILTER (
        ALL ( 'Table' ),
        'Table'[date] = SELECTEDVALUE ( 'Table'[open date] )
            && 'Table'[date] <= SELECTEDVALUE ( 'Table'[close date] )
            && 'Table'[date] = SELECTEDVALUE ( 'Table'[date] )
    )
)

Measure 2 = COUNTAX(FILTER(ALL('Table'),[Measure]<>BLANK()),[Measure])

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.