Count Yes

[Anonymous]

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 returns. How can I do this with Card filter

[v-luwang-msft]

Hi @Anonymous ,

Due to not with your data ,I create the below sample:

(if value>=4,then "Yes")

pd = IF(MAX('Table'[Value])>=4,"Yes",BLANK())

Then use the below measure:

count = COUNTX(FILTER('Table','Table'[pd]="Yes"),'Table'[Value])

count2 = COUNTX(FILTER(all('Table'),'Table'[pd]="Yes"),'Table'[Value])

Output result refer:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[SpartaBI]

@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"
)
)

      

Showcase Report – Contoso By SpartaBI

[Anonymous]

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".

[SpartaBI]

@Anonymous this is not how I wrote it 🙂
Let's try now with your names:
MEASURE = 
COUNTROWS(
FILTER(
'ITRMP Controls'
'ITRMP Controls'[Expiry] = "Yes"
)
)

      

Showcase Report – Contoso By SpartaBI