cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
matrix10
Frequent Visitor

Group by columns from two tables

Folks, new to PBI Desktop.
I am extracting user and group memberhsip data from Active Ditectory in PBI Desktop.
I have two tables (user, group) that are joined with a relationship (1 to many).


The table looks like this:

matrix10_0-1638056046965.png

 

I want to display the data in a tabular format as follows:

matrix10_1-1638056090202.png

 

It's basically group by username and usernumber.
How do I do that in DAX (or any other method)?
Thank you.

 

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

You can do something like this in a matrix visual by turning off the stepped layout.

View solution in original post

1 REPLY 1
AlexisOlson
Super User
Super User

You can do something like this in a matrix visual by turning off the stepped layout.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors