If statement to return a numeric value if column contains any value.

[JoanCampbell]

This is what I used 

Beginner here

My formula works : Count of Activity = IF(ISBLANK('Distribution'[ Activity]),"","1") 

But it returns a text vaule and I need it to be a numeric value, because I need to count them in a table by activity.  

Changing the Data type causes an error  

Please help

[AlexisOlson · Accepted solution]

Try returning a number instead of a text.

 Count of Activity = IF(ISBLANK('Distribution'[ Activity]),BLANK(),1)