Forum Discussion

Rth's avatar
Rth
New Member
3 years ago
Solved

Count with condition

Hi everyone, would anyone be able to help with a DAX calculation for the following?   I have a table including Name of the Project (projects are recurring) and Amount of Hours as columns. Now I wo...
  • Samarth_18's avatar
    Samarth_18
    3 years ago

    Hi Rth ,

     

    You could try below code:-

     

    m =
VAR _calc =
    FILTER (
        SUMMARIZE (
            'Table (5)',
            'Table (5)'[Name of Project],
            "_SUM", SUM ( 'Table (5)'[Column1] )
        ),
        [_SUM] >= 20
    )
RETURN
    COUNTROWS ( _calc )

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Rth 

Are you getting your problems solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.