How to get cero in my table but respecting filters???

[christianfcbmx]

 Hi dear Community, I need your help please.

I used to add a "+0" at the end of formulas that give a blank or empty spaces in tables.... I did the same thing with a formula I just made but is not working. ¿? I set the "+0" like in this example:  Visitas Sellers = CALCULATE(COUNT(Base[IDPROSPECTO]) +0;'dotacion (2)'[marca jefe] = 3)... This worked but its not the desired result because it makes show up evrything that contained empty spaces like the image two at the end of this post. (I mean, when I do this, the table is not respecting my filters)

I need cero and no empty spaces, anybody could give me a hand: my formula is:

Visitas Sellers = CALCULATE(COUNT(Base[IDPROSPECTO]);'dotacion (2)'[marca jefe] = 3)

this is the result:

[affan · Accepted solution]

Hi @christianfcbmx,

You can give a try to the following formula

Visitas Sellers = Var countbase=CALCULATE(COUNT(Base[IDPROSPECTO]);'dotacion (2)'[marca jefe] = 3)
Return IF(ISBLANK(countbase),0,countbase)

If you still have some issue please share your sample pibx file so that exact help can be provided

Please mark this post as an accepted solution if this helped you.

Regards,

Affan

[christianfcbmx]

I really Appreciate your Help!!!