How to count all 0's and 1's

[Anonymous]

Hi all,

I have an excel spreadsheet and I want to count al 0's and 1's seperate. The data is from a survey and 0 = no, 1 = yes.

Here is an example of the data:

Now if I try to visualize it, PowerBI doesn't count the 0's.

Is there a way to set this as a boolean or something?

Thanks!

[v-xuding-msft]

Hi @Anonymous 

In order to solve the problem, you need to do like this.

• 

• 

[Anonymous · Accepted solution]

I guess you selected sum not to count

[ibarrau]

Hi, you can do it in many ways depending on how you will design the page.

One way should be creating a measure COUNTROWS( 'Table' ). You can use that measure in a visualization and the column with 0 and 1 as filter (slicer) for the visualization.

If you want to keep the number static you can build a measure for that specific scenario like:

Measure column1 when 0 =
CALCULATE(
    COUNTROWS( Table ) 
    , Table[Column1] = 0
)

That second way will always show the total result of that column for 0.

Hope this helps,