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.
I have 4 tables with relationships:
- UA: IdUnit, UnitName, IdUnitDependents and informations about Units
IdUnitDependents is lilke 1 < 239 < 938 where each number corresponds a hierarchy IdUnit
- Adressess : Units Adressess, City, ZipCode
- Employees: NameofEmployee, UA (Employee IdUnit)
- UnitsExpenses: Expenses with maintenance of buildings
Need to calculate:
- Number of Employees in each UA (Unit), including dependents (need to search number inside IdUnitDependents column) like need to know count of employess with code 239 in IdUnitDependents
- Sum of Expenses with maintenance calculated for Unit including depentens same as Employess - is necessary to Divide Total Expenses per Adress than divide per Employes in this adress and then multiply per Employees of Unit with dependents
I have this formula to calculate expenses:
Per Person:
Per Unit:
Solved! Go to Solution.
Hi @AleMacedo ,
It's hard to reproduce your problem without a sample, could you please give an example to illustrate your problem?
Best Regards,
Community Support Team _ kalyj
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |