dividing the sum of one column by a fixed number

[VC1508]

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

[selimovd · Accepted 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
)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic