IF and calculation

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!