Forum Discussion

Fcoatis's avatar
Fcoatis
Icon for Post Patron rankPost Patron
9 years ago
Solved

Need help with this model v2

Hello again,   This is a new version of my previous post. I have this table:    I have to allocate total amount of each job following the rule 30% of total for doers divided by total doers ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Fcoatis,

     

    Sorry, it seems like I miss the the type column and only calculate the distinct value.(so the total amount not match the original amount)

     

    Modified formula:

    Table = SUMMARIZE(Allocation,[Job],[Name],[Group],[Type],
    "Date",LOOKUPVALUE(fMovement[Date],[Job],[Job]),
    "Actual Amount",LOOKUPVALUE(fMovement[Amount],[Job],[Job])*SWITCH([Group],"Doer",.3,"Handler",.7)/
    COUNTX(FILTER(ALLEXCEPT(Allocation,Allocation[Name]),[Job]=EARLIER([Job])&&[Group]=EARLIER([Group])),[Group]))

     

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Fcoatis,

 

Sorry, it seems like I miss the the type column and only calculate the distinct value.(so the total amount not match the original amount)

 

Modified formula:

Table = SUMMARIZE(Allocation,[Job],[Name],[Group],[Type],
    "Date",LOOKUPVALUE(fMovement[Date],[Job],[Job]),
    "Actual Amount",LOOKUPVALUE(fMovement[Amount],[Job],[Job])*SWITCH([Group],"Doer",.3,"Handler",.7)/
    COUNTX(FILTER(ALLEXCEPT(Allocation,Allocation[Name]),[Job]=EARLIER([Job])&&[Group]=EARLIER([Group])),[Group]))

 

 

Regards,

Xiaoxin Sheng

Fcoatis's avatar
Fcoatis
Icon for Post Patron rankPost Patron
9 years ago

AnonymousThank you very much. Not only worked but also learned a lot.

 

My best regards.