Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    you can try to unpivot all colums.

    Then group by attribute and value columns

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi Anonymous ,

If you want to use DAX to count it, you can unpivot all the columns in power query first, close and apply it.

Create a measure like this to count:

Count =
CALCULATE (
    COUNTROWS ( 'Table' ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Attribute]
            IN DISTINCT ( 'Table'[Attribute] )
                && 'Table'[Value] = TRUE ()
    )
)

Attached a sample file in the below, hopes to help you.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.