Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi guys,
I need your help. I want to have the same layout from this excel in a report in PBI:
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.
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
Solved! Go to Solution.
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 🙂
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 🙂
User | Count |
---|---|
98 | |
76 | |
74 | |
49 | |
26 |