topic Re: Data transformation help! in DAX Commands and Tips

Data transformation help!

Nonex20 — Tue, 02 Jul 2024 08:50:11 GMT

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?

Re: Data transformation help!

some_bih — Tue, 02 Jul 2024 09:01:25 GMT

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

Re: Data transformation help!

Anonymous — Wed, 03 Jul 2024 07:21:31 GMT

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