How to count True and False as a table value

[tipu500]

Hi, I have a table like this 

Barcoded

True

False

True

Now, I want to prepare a report and count True= ? and False= ? Another question, can I make alias for True and False so that I table will show the data like this:

Coded	Count
Barcoded	20
Not Barcoded	10

Is it possible? Can somebidy help me for this? 

[Ashish_Mathur · Accepted solution]

Hi,

Create a calculated column formula

Status = if(Data[Barcoded]=TRUE(),"Barcoded","Not barcoded")

To your Table visual, drag Status to the row labels and write this measure

Measure = countrows(Data)

Hope this helps.

[v-zhangti · Accepted solution]

Hi, @tipu500 

Please try the following methods.

Column:

Coded = IF([Barcoded]=True,"Barcoded",IF([Barcoded]=FALSE,"Not Barcoded"))

New Table:

Table 2 = 
SUMMARIZE('Table','Table'[Coded],"Count",COUNT('Table'[Coded]))

Is this the result you were expecting?

Best Regards,

Community Support Team _Charlotte

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

[Ashish_Mathur · Accepted solution]

Hi,

Create a calculated column formula

Status = if(Data[Barcoded]=TRUE(),"Barcoded","Not barcoded")

To your Table visual, drag Status to the row labels and write this measure

Measure = countrows(Data)

Hope this helps.