Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Count Blank Values in a Column

Hi Experts

 

I am trying to count the number of blank values in my table based on another column

Blank Values = CALCULATE(
COUNTROWS('STG Fact_To_Do'),
'STG Fact_To_Do'[Created_Date]=BLANK(),
FILTER('STG Fact_To_Do',ISBLANK('STG Fact_To_Do'[Closed]
 
So if the Created Date Column has blank rows based on the closed column which always has a value in - count the blank cells in Created date column

See Example Data - here we have 3 blank rows...

Created_DateClosed
14 August 20201
 1
23 July 20201
19 August 20201
 1
28 July 20201
 1
22 November 20191
20 August 20201



 
Need Help

11 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Try like

    countrows(filter('STG Fact_To_Do', isblank(Created_Date)))

     

    or

    calculate(countrows('STG Fact_To_Do'),filter('STG Fact_To_Do', isblank(Created_Date)))

  • VijayP's avatar
    VijayP
    Community Champion
    5 years ago

    Anonymous  

    Count = CALCULATE(COUNTROWS('Table (2)'),FILTER('Table (2)',ISBLANK('Table (2)'[Created_Date])))
    Try this 
    Regards
    Vijay Perepa
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      HI Vijay

       

      I am getting blank result in  score card....not the value 3

      • amitchandak's avatar
        amitchandak
        Super User
        5 years ago

        Anonymous , I was able to get 3 . Posted file in last update