Forum Discussion
countif column has entry (don't count blanks)
Community ChampionAnonymous, Sean 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.
In the event that there is something in them, like " " or something, the general format would be:
MyMeasure = CALCULATE(COUNT([NumericColumn]),FILTER(SomeTable[SomeColumn] <> ""))
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 " ".
Hope you get to the bottom of it.
Thanks but that formula is not working and potentially I'm doing it wrong
Airport Line = CALCULATE(count('EngagorData'[Tag-L3 » Airport Line]),FILTER('EngagorData','EngagorData'[Tag-L3 » Airport Line]<>""))
Above is the formula I used and it returns nothing.
In your formula you reference to "numericcolumn and sometable some column. am i missing something.
My data table is call "EngagorData" and the column is called "Tag-L3 » Airport Line". In each cell it is either blank or has the entry "Tag-L3 » Airport Line"
I have even tried this and returns nothing.
Airport Line = CALCULATE(count('EngagorData'[Tag-L3 » Airport Line]),FILTER('EngagorData','EngagorData'[Tag-L3 » Airport Line]="Tag-L3 » Airport Line"))
SeanWhat numbers do you get from each of these
COUNTROWS( ), COUNTA( ), COUNT( ) and COUNTBLANK( )
and what DATA TYPE is the column?
Got it working
Measure = COUNTA('EngagorData'[Tag-L3 » Airport Line]) - COUNTBLANK('EngagorData'[Tag-L3 » Airport Line])
- SeanI must not be understanding this question???