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.  ...
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"))

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"))