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
Your help will be greatly appreciated.
Go to Solution.
in the PQ, select count column and unpivot other columns.
then you get a new data layout
Then create a measure
Measure = CALCULATE(sum('Table'[count]),FILTER('Table','Table'[Value]="YES"))+0
Proud to be a Super User!
View solution in original post
@DianaT - @ryan_mayu is 100% correct, definitely the way to go.
@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.
You can unpivot the data
https://radacad.com/pivot-and-unpivot-with-power-biand use replace function in power query (on right click of column) and convert no to 0 and yes to 1
Then you can do simple addition
Thank you Ryan. Your solution works beautifully.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.