The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
182 | |
81 | |
64 | |
46 | |
38 |