Forum Discussion
Solved
Counting Rows with Zero Values
Plesae Help We are trying to update a system with proper contact information. The data I'm trying to report off of (attached) shows which accounts are missing an email, address and phone n...
The purpose of "Count Final Data" is to set up the measure that does the work itself. The other 3 measures simply call the measure and apply the additional constraints.
To get a percentage try something like:
Count PBI Email Pct = var denominator = [Count Final Data] var numerator = CALCULATE( [Count Final Data], 'Final Data Set'[PBI Email] = 0 ) RETURN DIVIDE(numerator, denominator)
Sorry forgot to add attachment... Here is what I have now.
The purpose of "Count Final Data" is to set up the measure that does the work itself. The other 3 measures simply call the measure and apply the additional constraints.
To get a percentage try something like:
Count PBI Email Pct = var denominator = [Count Final Data]
var numerator = CALCULATE(
[Count Final Data],
'Final Data Set'[PBI Email] = 0
)
RETURN
DIVIDE(numerator, denominator)