Count rows if Col1 AND Col2 are blank

[Anonymous]

Hello

I have this formula:

IF(SELECTEDVALUE(CurrentTable[Col1])="1",CALCULATE(COUNT(AnotherTable[Col2]),FILTER(AnotherTable,AnotherTable[Col3]=SELECTEDVALUE(CurrentTable[Col1])),AnotherTable[Col2]<>"")

How can I cound the rows that have empty-or-blank in all AnotherTable[Col2], AnotherTable[Col5], AnotherTable[Col7] while the other critera still apply, i.e. AnotherTable[Col3]=SELECTEDVALUE(CurrentTable[Col1]) ?

Thanks! 

[v-alq-msft]

Hi, @Anonymous 

Could you please show us some sample data and expected result with One Drive for business? Do mask sensitive data before uploading. Thanks.

Best Regards

Allan

[v-alq-msft]

Hi, @Anonymous 

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards

Allan

[v-alq-msft]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario.

CurrentTable:

AnotherTable:

You may create a measure as below.

Result = 
var _col1 = SELECTEDVALUE(CurrentTable[Col1])
return
IF(
    _col1 = "1",
    CALCULATE(
        COUNT(AnotherTable[Col2]),
        FILTER(
            ALL(AnotherTable),
            AND(
            AnotherTable[Col3]=_col1,
            AnotherTable[Col2]=BLANK()
            )
        )
    )
)

Result:

Best Regards

Allan

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

[lbendlin]

Please explain the issue again and provide some sample data and expected outcome.