Data transformation help!

[Nonex20]

My raw data the I upload in Power BI looks like this

Users	Site 1	Site 2	Site 3
User 1	Yes	No	No
User 2	No	Yes	No
User 3	No	No	Yes
User 4	Yes	No	No
User 5	No	Yes	No
User 6	No	No	Yes
User 7	Yes	No	No
User 8	No	Yes	No
User 9	Yes	No	No
User 10	No	No	Yes

I want to transfor it using dax looking like this 

Sites	Count of Users
Site 1	4
Site 2	3
Site 3	3

Can anyone suggest?

[some_bih · Accepted solution]

Hi @Nonex20 check link for unpivot in Power Query part of pbi file

[v-yaningy-msft · Accepted solution]

Hi, @Nonex20 

Thanks for @some_bih 's useful reply. Her is supplemental.

Step1: Choose site1, site2, site3 and right clock, use Unpivot Culomns feature.

Step2:
Use this dax to create a measure in desktop.

Count of users = 
CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table', 'Table'[Value] = "Yes" ) )

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[some_bih · Accepted solution]

Hi @Nonex20 check link for unpivot in Power Query part of pbi file