Forum Discussion

Marinus's avatar
Marinus
Icon for Helper I rankHelper I
10 months ago
Solved

Count blank rows if blank in 2 columns

I want to count blank rows, but only if blank in the columns 'BD Conflictenexports'[Acc.Pl.Toel.] and 'BD Conflictenexports'[Acc.Vd.Toel.]. Can you tell me the correct formula for this measure?
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    10 months ago

    Marinus 

     

    Download example file with this code

     

    Try this

     

    Count Blank Rows :=
COUNTROWS (
    FILTER (
        'BD Conflictenexports',
        ISBLANK ( 'BD Conflictenexports'[Acc.Pl.Toel.] ) 
        && ISBLANK ( 'BD Conflictenexports'[Acc.Vd.Toel.] )
    )
)

     

     

    Regards

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
10 months ago

Marinus 

 

Download example file with this code

 

Try this

 

Count Blank Rows :=
COUNTROWS (
    FILTER (
        'BD Conflictenexports',
        ISBLANK ( 'BD Conflictenexports'[Acc.Pl.Toel.] ) 
        && ISBLANK ( 'BD Conflictenexports'[Acc.Vd.Toel.] )
    )
)

 

 

Regards

 

Phil