countif column has entry (don't count blanks)

Question

Hi,&nbsp;I need to be able to count the number of entries in a data column and not count the blanks.&nbsp;So for example under a column labelled "tag 1" there maybe 25,000 rows but only 150 entries with the other 24,850 rows left blank. I want the count to return 150.&nbsp;Thanks,

anonymous · Answer

Got it workingMeasure = COUNTA('EngagorData'[Tag-L3 » Airport Line]) - COUNTBLANK('EngagorData'[Tag-L3 » Airport Line])

sean · Answer

Anonymous&nbsp;Try COUNTA( )&nbsp;Here are the other counting functions...https://msdn.microsoft.com/en-us/library/ee634956.aspx&nbsp;

anonymous · Answer

Already tried COUNTA and it counts all the rows.

sean · Answer

Okay - so what does COUNTBLANK( )give you then? You are creating Measures right?

greg_deckler · Answer

Anonymous,&nbsp;Sean&nbsp;is correct that if the data in those rows truly was empty that COUNTA should count them the way you describe and COUNTBLANK can be used to determine if they truly are blank.&nbsp;In the event that there is something in them, like " " or something, the general format would be:&nbsp;MyMeasure = CALCULATE(COUNT([NumericColumn]),FILTER(SomeTable[SomeColumn] &lt;&gt; ""))The above formula is essentially the equivalent of COUNTA. The advantage here is that if it is truly not empty (blank) then you can adjust the "" in the formula to something like " ".&nbsp;Hope you get to the bottom of it.

Forum Discussion

countif column has entry (don't count blanks)

10 Replies

Related content

Remove Blank Columns

CountIf Multiple Columns

Index Countif

Countifs

Blank Page - Embedded Report