Forum Discussion
Create table from multiple true/false columns using DAX
I have a table with 12 columns of true/false data. I need to be able to present the number of true values per column. Though I was able to get this done my process is not repeatable nor is it elegant...
Anonymous
you can try to unpivot all colums.
Then group by attribute and value columns
What I ended up doing was to copy the table, delete all of the rows that I didn't need, unpivoted the table and that gave me what I needed. I kept an ID field so that I could relate it to the original table.
Thank you for helping and offering suggestions.