Forum Discussion
IF and calculation
Hi, how can I calculated that how many value '1' and value '0' appears in the column?
Thanks for help!
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!
3 Replies
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!Calc_0_and_1 = CALCULATE ( COUNT ( 'Table'[Column1] ), 'Table'[Column1] IN {0,1} )Just to give some more options! :)
Robbe
You will have to Use CALCULATE:
CALCULATE( COUNT(XXX), Category =0 || 1 )
