Forum Discussion
Data transformation help!
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?
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 TeamIf 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
2 Replies
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 TeamIf 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