Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
Hello,
I would need a help for this calculation. Here below an example of data.
I have to divide the sum of column “workload” by a fixed number “1680”.
Column “workload” is the result of multiplication by columns “standard time”, “# activities”, # FTEs”.
How can I do?
Department | Activities | Standard Time | # activities | # FTEs | Workload |
Info A | ACT 1 | 0,5 | 1020 | 1,0 | 510 |
Info A | ACT 2 | 4,0 | 174 | 1,0 | 696 |
Info A | ACT 3 | 2,0 | 1 | 1,0 | 2 |
Info A | ACT 4 | 0,5 | 1216 | 1,0 | 608 |
Info A | ACT 5 | 2,0 | 1216 | 1,0 | 2432 |
Info A | ACT 6 | 12,0 | 50 | 1,0 | 600 |
Info A | ACT 7 | 1,0 | 210 | 1,0 | 210 |
Solved! Go to Solution.
Hey @VC1508 ,
if you want to have it depending by other filters, you can just use the following DAX measure:
Workload Divided =
DIVIDE (
SUMX (
myTable,
myTable[Standard Time] * myTable[# activities] * myTable[# FTEs]
),
1680
)
If you always want to calculate if for the whole table you can use the following measure:
Workload Divided =
DIVIDE (
SUMX (
ALL( myTable ),
myTable[Standard Time] * myTable[# activities] * myTable[# FTEs]
),
1680
)
Hey @VC1508 ,
if you want to have it depending by other filters, you can just use the following DAX measure:
Workload Divided =
DIVIDE (
SUMX (
myTable,
myTable[Standard Time] * myTable[# activities] * myTable[# FTEs]
),
1680
)
If you always want to calculate if for the whole table you can use the following measure:
Workload Divided =
DIVIDE (
SUMX (
ALL( myTable ),
myTable[Standard Time] * myTable[# activities] * myTable[# FTEs]
),
1680
)
User | Count |
---|---|
91 | |
74 | |
71 | |
58 | |
55 |
User | Count |
---|---|
41 | |
39 | |
34 | |
32 | |
30 |