Divide value but number of people and spread them equally per person

[paulfink]

Hi guys,

Need some help with this.

I have a field that shows how many should be spent on a task.

I need to divide that field by the number of people on that task then have that divided number spread out throughout the task so each person gets an equal amount of hours to work to.

Based on my dummy data.

The hours would be divided by 3 and are spread across each of the people.

How could i do this?

[paulfink]

@Greg_Deckler @amitchandak I used both of yours and got a "A circular dependency was detected"

I have a calc column that goes into a measure then im using that measure in the formula that is getting the circular dependency.

What does this mean and how do i fix it

Is it possible to make this into a measure?

[v-shex-msft]

Hi @paulfink,

Did Greg_Deckler 's sample works on your side? If this is a case, you can consider accepting his solution to help other users who faced the same scenario.

If not help, please share a dummy pbix file then we can test and troubleshoot on your formulas.

Regards,

Xiaoxin Sheng

[Greg_Deckler · Accepted solution]

@paulfink It basically means that one calculation is dependent upon another calculation that depends on the previous calculation. It's a DAX check to prevent recursion and it is a real pain. But, regardless of that, yes, you can make this a measure. See Page 23 of attached PBIX below sig.

Measure 23 = 
    VAR __Task = MAX([Task])
    VAR __Table = FILTER(ALL('Table (23)'),[Task]=__Task)
    VAR __Average = AVERAGEX(__Table,[Hours])
RETURN
    __Average

[Greg_Deckler]

@paulfink - Thinking:

Column = AVERAGEX(FILTER('Table',[Task]=EARLIER('Task')),[Hours])

[amitchandak]

@paulfink , Try like

new column =
var _1 = sumx(filter(Table,[Task] = earlier([Task])),[Hours])
var _2 = countx(filter(Table,[Task] = earlier([Task])),[Hours])
return
divide(_1,_2)