Forum Discussion
Count Yes
Hello, I have a measure that counts whether or not a contract is expiring within a certain amount of days. The measure outputs either 'Yes' or 'No.' I want to count all the 'Yes' values it return...
Anonymous something in the form of:
MEASURE =
COUNTROWS(
FILTER(
'The relvant table or combination of columns that when putting the measure next to them you get the right result',
[Your Measure] = "Yes"
)
)
The name of the measure is "Expiry". And whenever I try and call it in the table i getan error saying "Parameter is not the correct type".
Anonymous this is not how I wrote it 🙂
Let's try now with your names:
MEASURE =
COUNTROWS(
FILTER(
'ITRMP Controls'
'ITRMP Controls'[Expiry] = "Yes"
)
)