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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Both DAX formula return back blank as oppsed to the value 3