Forum Discussion

New Member

3 years ago

COUNT IF With Group By ?

Hi, Hello, I have a table with this datas. I would like to add a new column to count the number of IDs per Order for which the OtherID field is not null. My datas : Order ID ...

Need Help

Mathais_

New Member

3 years ago

A criterea was missing :

Now, how can I force 0 instead of blank value when All Table1[OtherID] values are blank ?

NotNullOtherID = 
CALCULATE(
    COUNTROWS(Table1),
    FILTER(
        Table1,
        NOT(ISBLANK(Table1[OtherID])) && 
        Table1[Order] = EARLIER(Table1[Order]) &&
        Table1[ID] = EARLIER(Table1[ID])
    )
)