Count True/False and represent in chart using percentage

[bh_prism]

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

[Icey · Accepted solution]

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.

[amitchandak]

@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()

[tex628]

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

[bh_prism]

Hi, yes it is boolean data type. Thanks

[tex628]

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