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

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      Anonymous ,

      +0 to a measure and count zeros. Can you share the complete sample?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi AMit

         

        I cannot upload a file nor send a drobox link. If you create a simple DIM Date Table and link DAte from Dim DAte to Created Date in FACT table and see if the measure works