Forum Discussion
Count rows with criteria
Hi I have a table that lets me know if people are on target.
I would like to have a count for those that are yes and those that are no. Below is the measure i wrote
Count if Expected to make target = CALCULATE(COUNTROWS(WIP), [AA Expected to make target]="Yes"), but recieved the below error message
Anonymous ,
Taking a leap of faith here, but I think you need a TableName 'WIP' before "[AA.....].
CALCULATE(COUNTROWS(WIP), WIP[AA Expected to make target]="Yes")
Hoping this fixes your issue. If not, if you can upload the file and I will try to have a closer look.
Regards,
1 Reply
Anonymous ,
Taking a leap of faith here, but I think you need a TableName 'WIP' before "[AA.....].
CALCULATE(COUNTROWS(WIP), WIP[AA Expected to make target]="Yes")
Hoping this fixes your issue. If not, if you can upload the file and I will try to have a closer look.
Regards,