Forum Discussion

saivina2920's avatar
saivina2920
Post Prodigy
5 years ago
Solved

Getting count difficult from column values like true or false in power bi

I have column like status1 snd status2. These column contains true or false. 

 

i am getting count in difficult from column values like true or false.

 

How to achieve and get the exact count.

 

Sample data and Epected OUTPUT as mentioned below.

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    saivina2920 , Create two measures like

     


    counrows(filter(Table, Table[Status1] =True()))

    and

    counrows(filter(Table, Table[Status2] =True()))

     

    if they are boolean then

     


    counrows(filter(Table, Table[Status1] ="TRUE"))

     

    and

     

    counrows(filter(Table, Table[Status2] ="TRUE"))

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    saivina2920 , Create two measures like

     


    counrows(filter(Table, Table[Status1] =True()))

    and

    counrows(filter(Table, Table[Status2] =True()))

     

    if they are boolean then

     


    counrows(filter(Table, Table[Status1] ="TRUE"))

     

    and

     

    counrows(filter(Table, Table[Status2] ="TRUE"))