Forum Discussion
abeirne
Helper II
Helper IIHelp with count measure (true/false expression does not specify a column)
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 = ...
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 🙂
SpartaBI
Community Champion
Community Championabeirne 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 🙂
abeirneHelper II
Helper IIThanks! My divide was also backwards but the measure is working now 🙂