Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
Tutorial Requests
v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

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