Forum Discussion
How to effectively vizualize binary information?
- 7 years ago
Hi Anonymous ,
I'm a little confused about your requirement.
Do you want to show the count of 0 and 1 for each category?
If it is, you could try this below.
1. Unpivot other columns in query editor.
2. Create the two measures.
count of 0 = CALCULATE ( COUNT ( 'PME selon champs tech'[Value] ), FILTER ( ALLEXCEPT ( 'PME selon champs tech', 'PME selon champs tech'[cate] ), 'PME selon champs tech'[Value] = "0" ) ) count of 1 = CALCULATE ( COUNT ( 'PME selon champs tech'[Value] ), FILTER ( ALLEXCEPT ( 'PME selon champs tech', 'PME selon champs tech'[cate] ), 'PME selon champs tech'[Value] = "1" ) )More details, you could refer to my attachement.
If you still need help, please share your desired output so that we could help further on it.
Best Regards,
Cherry
Hi Anonymous ,
I'm a little confused about your requirement.
Do you want to show the count of 0 and 1 for each category?
If it is, you could try this below.
1. Unpivot other columns in query editor.
2. Create the two measures.
count of 0 =
CALCULATE (
COUNT ( 'PME selon champs tech'[Value] ),
FILTER (
ALLEXCEPT ( 'PME selon champs tech', 'PME selon champs tech'[cate] ),
'PME selon champs tech'[Value] = "0"
)
)
count of 1 =
CALCULATE (
COUNT ( 'PME selon champs tech'[Value] ),
FILTER (
ALLEXCEPT ( 'PME selon champs tech', 'PME selon champs tech'[cate] ),
'PME selon champs tech'[Value] = "1"
)
)
More details, you could refer to my attachement.
If you still need help, please share your desired output so that we could help further on it.
Best Regards,
Cherry