Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
VC1508
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
selimovd
Super User
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
 

View solution in original post

1 REPLY 1
selimovd
Super User
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
 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.