cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
themistoklis New Contributor
New Contributor

Re: Count the number of rows containing specific text

@LeighMacKay


Can you try these formulas and see if they work?

 

Activations_Count = CALCULATE( COUNT('eventminder_a_trinity activity_log'[description]), 
                                     'eventminder_a_trinity activity_log'[description] = "Activated Account",
                                     'eventminder_a_trinity activity_log'[email_verified_by] <> BLANK()								 
							 )
							 
OR

Activations_Count = CALCULATE( COUNT('eventminder_a_trinity activity_log'[description]), 
                                     'eventminder_a_trinity activity_log'[description] = "Activated Account",
                                     LEN('eventminder_a_trinity activity_log'[email_verified_by]) = 0 									 
							 )