Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

COUNTBLANK and Count Zeroes?

Hello,   I have a several columns that have text values and I want a DAX that could count how many Blanks there are AND how many zeroes there are. I already use the COUNTBLANK DAX but I would like ...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    How about something like this?

     

     

    COUNTROWS ( FILTER ( Table1, ISBLANK ( Table1[ColA] ) || Table1[ColA] = "0" ) )

     

    Or a completely different approach:

     

    CALCUALTE ( COUNT ( Table1[ColA] ), ISBLANK ( Table1[ColA] ) ) + 
CALCUALTE ( COUNT ( Table1[ColA] ), Table1[ColA] = "0" )

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Tahreem24 not sure why, FILTER function is the last thing you want to use. Anyhow, let's talk about it separately, don't want to divert the topic into something totally different. 👍