Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I've found some simillar issues, but can't make my report to work (cant post results as it is not public data).
I want to use yellow fields in report view, when 'Heacount' is calculated as below.
Sorry for non-english fileds, Rok-Miesiac is Year-Month and it is connected to Calendar (Kalendarz).
Any suggestions what could I do to get the right data?
Headcount = CALCULATE(SUM(headcount[Zatrudnienie]);USERELATIONSHIP(headcount[Rok-Miesiac]; Kalendarz[Rok-Miesiąc]))
Solved! Go to Solution.
Hi @Anonymous ,
Based on my test, you could refer to below steps:
Column = LOOKUPVALUE('Headcount'[Headcount],'Headcount'[Year-Month],'Unused holiday'[Year-Month],Headcount[Departement],[Department])
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi @Anonymous ,
It is hard to reproduce your problem, could you plesase post a simple sample that I could help you to have a test?
Regards,
Daniel He
Ok, so I've created quick example data. I have the following tables:
Headcount:
Unused holiday data:
Relationship by Department and Year-Month as below (Calendar table generated by functions CALENDAR...)
What I want, is to have in one table (Table A) columns like below. The problem is, that I can't find the solution to have both relationships working at same time - Departement<->Departement and Year-Mont<->Year Month.
In Table B you can see the Headcount by mont measure working fine, in Table A it is not.
This measure formula is as below.
Hope it is more clear now:)
Headcount by month = CALCULATE(SUM(headcount[Headcount]); USERELATIONSHIP('Calendar'[Year-Month];headcount[Year-Month]))
Anybody have an idea how I could make this kind of relationship to work?
Hi @Anonymous ,
Based on my test, you could refer to below steps:
Column = LOOKUPVALUE('Headcount'[Headcount],'Headcount'[Year-Month],'Unused holiday'[Year-Month],Headcount[Departement],[Department])
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Thanks!
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |