Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, how can I calculated that how many value '1' and value '0' appears in the column?
Thanks for help!
Solved! Go to 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!
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 )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |