Help with a CountIf function in Power BI

Anonymous 

why 2 for project A? We only see one Date in Service for project A.

pls see if this is what you want

Column = countx(FILTER('Table','Table'[B]=EARLIER('Table'[B])&&'Table'[C]="Date In Service"),'Table'[B])

 

You can create a calculated column like that in your table
Please see, if this is what you want

ColumnA =

CALCULATE(

    COUNTROWS(Project),

    FILTER(

        Project,

        Project[ColumnB] = EARLIER(Project[ColumnB]) &&

        Project[ColumnC] = "Date In Service"

    )

)

 

Hi Anonymous 

Thanks for the reply from ryan_mayu and muhammad_786_1.

Anonymous , you can create a calculated column as follows

Column = CALCULATE(COUNT('Table'[B]), FILTER(ALLEXCEPT('Table', 'Table'[B]), [C] = "Date In Service"))

Output:

Best Regards,
Yulia Xu

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