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,
I am trying to accomplish something, but don't know how to do it.
I have a Dimension (Table) that represents time entries for employees like so :
Id | EmployeeId | EntryDT | TimeInMinutes | PriceAgreementId |
1 | 1 | 2017-03-20 | 100 | 1 |
2 | 1 | 2017-03-31 | 50 | null |
3 | 2 | 2017-03-21 | 100 | 1 |
4 | 2 | 2017-03-23 | 125 | 2 |
5 | 3 | 2017-03-15 | 90 | null |
6 | 3 | 2017-03-25 | 60 | 1 |
Sometimes they work on "PriceAgreements", and sometimes they don't).
In my Dashboard, i have a Table that groups that table by EmployeeId and Sums the TimeInMinutes. I also have a Slicer for EntryDT :
EmployeeId | TimeInMinutes |
1 | 150 |
2 | 225 |
3 | 150 |
I need to create 2 new columns that represent :
So the Table would look like this (without the PriceAgreementIds in parenthesis) :
EmployeeId | TimeInMinutes | TimeInMinutes on PriceAgreements | TimeInMinutes on PriceAgreements ALL other EmployeeIds |
1 | 150 | 100 (PriceAgreementId=1) | 260 (PriceAgreementId=1) |
2 | 225 | 225 (PriceAgreementId=1 and 2) | 385 (PriceAgreementId=1 and 2) |
3 | 150 | 150 (PriceAgreementId=1) | 260 (PriceAgreementId=1) |
Column "TimeInMinutes on PriceAgreements" is quite easy, but the other one, i cannot find a solution...
I have this DAX expression I started, but it is not complete:
CALCULATE(SUM(TEntry[EmployeeTimeInMinutes]), NOT ISBLANK(TEntry[PriceAgreementId]), ALL(TEmployee))
TEmployee is a Dimension linked to the main Entry Table.
Any help would be appreciated.
Thank you.
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |