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 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?

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!

     

     


     

3 Replies

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

  • 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!