Easy Calculation

[Anonymous]

Hi @ all,

I would like to calculate the following: "Workload Person/Activity"

Person                            Activity                  Workload                                   Workload Person/Activity

A	1	50%	70%
A	1	20%	70%
A	2	30%	30%
B	1	10%	20%
B	1	10%	20%
B	2	80%	80%

This should be a simple DAX formula but I just can't figure it out 🙂

[petrovnikitamai · Accepted solution]

new column = sumx(filter(TableName;earlier([Person])=[Person]&&earlier([Activity])=[Activity]);[Workload])

try this

[Anonymous]

works perfectly, thanks!