topic Help with count measure (true/false expression does not specify a column) in DAX Commands and Tips

Help with count measure (true/false expression does not specify a column)

abeirne — Thu, 05 May 2022 16:03:32 GMT

Hi all, I am trying a measure that calculates % of valid emails. I have the column filtered in power query and outputs "Not Valid" when email does not meet a certain criteria.

% Valid Emails =

VAR Valid =

CALCULATE(

COUNT(Invoice_Tb[Customer Email (Clean)]),

SELECTEDVALUE(Invoice_Tb[Customer Email (Clean)]) <> "Not Valid"

)

VAR PercentDiv =

DIVIDE(

COUNT(Invoice_Tb[Customer Email (Clean)]),

Valid

)

RETURN

PercentDiv * 100

I keep getting the error "The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column." Not sure what to do. Thanks

Re: Help with count measure (true/false expression does not specify a column)

SpartaBI — Thu, 05 May 2022 16:10:46 GMT

abeirne hey, try this:

% Valid Emails = VAR Valid = CALCULATE( COUNT(Invoice_Tb[Customer Email (Clean)]), Invoice_Tb[Customer Email (Clean)] <> "Not Valid" ) VAR PercentDiv = DIVIDE( COUNT(Invoice_Tb[Customer Email (Clean)]), Valid ) RETURN PercentDiv * 100

In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂

Re: Help with count measure (true/false expression does not specify a column)

abeirne — Thu, 05 May 2022 16:39:01 GMT

Thanks! My divide was also backwards but the measure is working now 🙂