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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.