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

Need Help
Tutorial Requests

4 Replies

  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

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

  • 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