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

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