Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |