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!

     

     


     

samratpbi's avatar
samratpbi
Super User
2 years ago

There are many options. Easiest option may be apply a filter on your card visual with column value = Yes. Or you may create a measure like below:

Count Y =
CALCULATE(
    COUNT(T1[Y/N]),
    T1[Y/N] = "Y"
)
 
If this resolves your provlem, then please mark it as Solution. Thanks
  • Belindah's avatar
    Belindah
    Frequent Visitor
    2 years ago

    Thank you! I will try first thing tomorrow and mark as solution if it works for me.