cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## dividing the sum of one column by a fixed number

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
1 ACCEPTED SOLUTION
Super User

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

Super User

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors