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(), ...
Need Help
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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Ok i forgot to mention my FACT Table TO DO links to a DIM Date table (1 to *) relationship Date to Created Date (FACT Table). i am still getting blank values???

      • VijayP's avatar
        VijayP
        Community Champion
        5 years ago

        Anonymous 

        Then Formula will be calculate(countrows(facttable),filter(all(datestable),isblank(datesinfacttable))