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
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)

      )

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        See Below: All of my tables are Related Direct Queires from SQL. I am wanting to track how many loans are in the application process.

         

        To do so, I am using dates. So in my main database, I am wanting to know how many loans that have an application date, but do not have an assigned date.