IF and calculation

[Sisko]

Hi, how can I calculated that how many value '1' and value '0' appears in the column?

Thanks for help!

[zoloturu · Accepted solution]

Hi @Sisko ,

Calc_0_and_1 =
CALCULATE (
    COUNT ( 'Table'[Column1] ),
    'Table'[Column1] = 0
        || 'Table'[Column1] = 1
)

This calculation does count of values in a field 'Table'[Column1] with either 0 either 1 value.

|| symbol is an equivalent of OR. So you can solve it in another way as well:

Calc_0_and_1 =
CALCULATE (
    COUNT ( 'Table'[Column1] ),
    OR ( 'Table'[Column1] = 0, 'Table'[Column1] = 1 )
)

The only difference between OR and || symbol that, actually OR is limited to 2 arguments.

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!

[RobbeVL]

Calc_0_and_1 = 
CALCULATE (
    COUNT ( 'Table'[Column1] ),
    'Table'[Column1]  IN {0,1}
)

Just to give some more options! 🙂 

Robbe 

[RobbeVL]

You will have to Use CALCULATE:

CALCULATE( COUNT(XXX), Category =0 || 1 )