Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Logical Count Function.

I am trying to calclulate the following: When a certain date is blank, count a related date.   IF(IsBlank(A Date)          ,COUNT(B Date)                      ,Blank()   *This is a direct query...
CALCULATE
DAX
DAX Calculation
Measures
speedramps's avatar
speedramps
Super User
6 years ago

Hi TSP

 

Please consider this solution and leave kudos

 

COUNTBLANK(<columnname>)

 

this will count the number of rows with a blank value in the column.

Note it will return 0 if there are rows but no blanks,
but will retrun blank if the table has no rows at all.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the suggestion, but I am wanting to count "B" Date if "A" date is blank.

 

 

  • speedramps's avatar
    speedramps
    Super User
    6 years ago

    Hi again TSP

     

    Please consider this solution and leave kudos

     

    Mycounter =
    CALCULATE(COUNT('MyTable'[MyColumnB),
    FILTER('MyTable'[MyColumnA)=BLANK())
    )
     
    The filter just selects the rows with ColumnA = blank
    then the count counts the remaining rows with a populated ColumnB.
    Any rows with a blank ColumnB will not be counted.
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Would it matter if the blank date is in a different table? I am not getting any errors, but the count is not showing on a card.

       

      Thank you,

      • speedramps's avatar
        speedramps
        Super User
        6 years ago

        Please can you elborate and describe the 2 files.

         

        Are you saying you have 2 files each with a list of dates and you want to count which dates are on table A but not on table B?

         

        This will count dates on B but not on A

         

        My count =

        VAR lista = VALUES(tableA[date])
        VAR listb = VALUES(tableB[date])
        RETURN
        COUNTROWS(

        EXCEPT(listb, lista)

        )