Forum Discussion

Helper I

7 years ago

Solved

IF and calculation

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

Memorable Member

7 years ago

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!

Impactful Individual

7 years ago

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

Just to give some more options! :)

Robbe