Power BI Report Help Please

[Belindah]

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 yes or no, with the default choice being no. When I add that column to the card, it just gives me the total number of the rows that have either entry. The only option I see to choose between the two is in the drill down, which I don't want because that changes everything else as well. Is there a way I can do this?

[Uzi2019 · Accepted solution]

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]

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]

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