Forum Discussion
Filter by related table
Hi guys, I am building a report in Power BI and I want to show the hours of the teams in my company. For one visual I need the table Projects and TimeTransactions, for another I need just the Ti...
try this measure:
Quantity_New = CALCULATE ( SUM ( 'TimeTransactions'[Quantity] ), TREATAS ( VALUES ( EmployementOrganization[Employee] ), Employees[Employee] ) )it shows the same values for Department 1 and 3, but I think that's because Employee A is in both departments
Stachu
Community Champion
Community Championtry this measure:
Quantity_New =
CALCULATE (
SUM ( 'TimeTransactions'[Quantity] ),
TREATAS ( VALUES ( EmployementOrganization[Employee] ), Employees[Employee] )
)it shows the same values for Department 1 and 3, but I think that's because Employee A is in both departments
Works like a charm, Thanks!
- Stachu
glad to help, have a good day 🙂