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 )

     

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
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 )