Forum Discussion

bh_prism's avatar
bh_prism
New Member
6 years ago
Solved

Count True/False and represent in chart using percentage

Hey guys

 

Hopefully someone can help. I have two columns in a table which reports TRUE or FALSE based on criteria being met.

 

I wish to have the count of TRUE/FALSE and represent the difference between 8 TRUE and 2 FALSE as 80% / 20% in a visual chart. 

 

How is this possible, I have played with Measures and filters but cant seem to get it working as I need it. 

 

Thanks, Ben

Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi bh_prism ,

     

    If I understand you correctly, put the below measure into a card visual and you'll get what you want:

    TRUE/FALSE =
VAR TRUE_ =
    CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Column1] = TRUE () )
        + CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Column2] = TRUE () )
VAR FALSE_ =
    CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Column1] = FALSE () )
        + CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Column2] = FALSE () )
VAR Total_ =
    COUNTROWS ( 'Table' ) * 2
VAR TRUE_Percent =
    DIVIDE ( TRUE_, Total_, BLANK () )
VAR FALSE_Percent =
    DIVIDE ( FALSE_, Total_, BLANK () )
RETURN
    TRUE_Percent & " / " & FALSE_Percent

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Does the columns have the boolean true/false data type?

    • bh_prism's avatar
      bh_prism
      New Member
      6 years ago

      Hi, yes it is boolean data type. Thanks

      • tex628's avatar
        tex628
        Icon for Community Champion rankCommunity Champion
        6 years ago

        Try these two measures:

        True = 
VAR True_ = CALCULATE(COUNTROWS('Table') , 'Table'[Column1] = TRUE())
VAR Total = COUNTROWS('Table')
Return
DIVIDE(True_,total,blank())
        False = 
VAR Total = COUNTROWS('Table')
VAR False_ = CALCULATE(COUNTROWS('Table') , 'Table'[Column1] = FALSE())
Return
DIVIDE(False_,Total,BLANK())


        They calculate the % for one column. Use them together in a chart to get the distribution for that column.

        / J

         

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    bh_prism , you can have measures like these

    divide(calculate(countrows(Table), table[flag]= "True"),calculate(countrows(Table))) // if boolean , table[flag]= True()
    divide(calculate(countrows(Table), table[flag]= "False"),calculate(countrows(Table))) // if boolean , table[flag]= False()

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi bh_prism ,

     

    If I understand you correctly, put the below measure into a card visual and you'll get what you want:

    TRUE/FALSE =
VAR TRUE_ =
    CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Column1] = TRUE () )
        + CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Column2] = TRUE () )
VAR FALSE_ =
    CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Column1] = FALSE () )
        + CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Column2] = FALSE () )
VAR Total_ =
    COUNTROWS ( 'Table' ) * 2
VAR TRUE_Percent =
    DIVIDE ( TRUE_, Total_, BLANK () )
VAR FALSE_Percent =
    DIVIDE ( FALSE_, Total_, BLANK () )
RETURN
    TRUE_Percent & " / " & FALSE_Percent

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.