Forum Discussion

Belindah's avatar
Belindah
Frequent Visitor
2 years ago
Solved

Power BI Report Help Please

Hi. I'm creating a Power BI report from a Teams List that I imported. The problem I'm having is I want to create a card that gives me the total number of Yes entries in a column that has a choice of ...
Need Help
  • Uzi2019's avatar
    Uzi2019
    2 years ago

    Hi Belindah
    I have created smample data and created measure on choice column. please refer screenshot FYR.

    Count = CALCULATE(COUNT('Table Name'[Choice]),'Table Name'[Choice]="yes")

    I hope I answered your question!

     

     


     

Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi Belindah
I have created smample data and created measure on choice column. please refer screenshot FYR.

Count = CALCULATE(COUNT('Table Name'[Choice]),'Table Name'[Choice]="yes")

I hope I answered your question!