Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

not getting the right count using countrows

I'm using a measure to count the number of rows in a column "Parked at School" that is a "Y". What is happening is the card visualization is showing a much higher number than the actual. If I click o...
Need Help
FrankAT's avatar
FrankAT
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous ,

use the following measure:

 

How often parked at School = CALCULATE(COUNT('Table'[Parked at School]);'Table'[Parked at School] = "Y")
 
Regards FrankAT