Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Johan-MTM
Helper III
Helper III

Combine two columns

Hi guys,
I need your help. I want to have the same layout from this excel in a report in PBI:

JohanMTM_0-1695713862797.png

First column is library name but second column is a combination of two columns - number of loans(Antal lån) and borrower_role(Roll vid lån) where the column "Antalet lån vuxna låntagare" show number if loans done by adults.

 

To have the same layout in PBI i guess I have to combine these two columns into one (this is called calculated column right?), where number of loand done by  only adults is shown in one column.

JohanMTM_1-1695714115344.png

Would anyone be so kind and show me some dax in how this can be done? Or is there another, better way to do it?
Thanks!

edit: spelling and explaining 

1 ACCEPTED SOLUTION
Johan-MTM
Helper III
Helper III

I did a new meassure instead:

 

Antal lån vuxna låntagare =
CALCULATE( DISTINCTCOUNT( 'public loan'[id] ) ,
'public loan'[Roll vid lån] = Patron() )

 

This solved my issue 🙂

View solution in original post

1 REPLY 1
Johan-MTM
Helper III
Helper III

I did a new meassure instead:

 

Antal lån vuxna låntagare =
CALCULATE( DISTINCTCOUNT( 'public loan'[id] ) ,
'public loan'[Roll vid lån] = Patron() )

 

This solved my issue 🙂

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors