Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

probably simple calculate problem

I want to make a calculated column which will give me a subtotal of one column devided by another column, based on two other columns as filters.    I have a data set like this that covers 13 months...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    Anonymous 

     

    Please try this

    Column = 
VAR ag_co= CALCULATE(sum(test[Completed Orders]),FILTER(test,test[Period]=EARLIER(test[Period])&&test[Agent Group]=EARLIER(test[Agent Group])))
VAR ag_wd = CALCULATE(sum(test[Possible Work days]),FILTER(test,test[Period]=EARLIER(test[Period])&&test[Agent Group]=EARLIER(test[Agent Group])))
return ag_co/ag_wd

     

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
6 years ago

Anonymous 

 

Please try this

Column = 
VAR ag_co= CALCULATE(sum(test[Completed Orders]),FILTER(test,test[Period]=EARLIER(test[Period])&&test[Agent Group]=EARLIER(test[Agent Group])))
VAR ag_wd = CALCULATE(sum(test[Possible Work days]),FILTER(test,test[Period]=EARLIER(test[Period])&&test[Agent Group]=EARLIER(test[Agent Group])))
return ag_co/ag_wd

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Legend, Thanks so much!