Forum Discussion
Transform boolean matrix into count?
Hi all,
I have a data set that looks like this:
Is it possible for Power BI to transform the boolean matrix into something like this:
Grad cohort Count
GradPre1970 0
Grad70-79 0
Grad80-89 11,882
Grad90-99 20,401
etc.
Your help will be greatly appreciated.
Cheers,
Diana
4 Replies
Thank you Ryan. Your solution works beautifully.
DianaT , if you want to keep them as column
GradPre1970 new = if([GradPre1970] ="No",0,1)
for each column and sum up.
In matrix, you can show them on the row.
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
You can unpivot the data
https://radacad.com/pivot-and-unpivot-with-power-bi
and use replace function in power query (on right click of column) and convert no to 0 and yes to 1https://www.youtube.com/watch?v=UZQ9EFvEECY
Then you can do simple addition
