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

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