Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculations in DAX table

So I am creating this DAX table and i have defined two measure. 

 

"SumOfSeconds"

"SumOfCalls" 

 

Now I want to make a new column that divides these two columns. I tried to add another column to the table and use the Divide function to accomplish this but cant seem to figure it out. 

 

The Table definition I have so far is: 

 

ASA = GROUPBY(

'ReportC_Group Pefromacne By Date', DeptLink[Department], DimDate[Date],

 

"SumOfSeconds", Sumx(CURRENTGROUP(), ('ReportC_Group Pefromacne By Date'[Cmltv wait time before answered (Sec)])),

 

"SumOfCalls",Sumx(CURRENTGROUP(), ('ReportC_Group Pefromacne By Date'[ACD calls answered]))

)

 

Could anyone provide a little insight?

  • Anonymous's avatar
    Anonymous
    7 years ago

    I was able to accomplish what I was looking to do by creating a calculated column rather than doing it in the DAX formula. Thanks for looking at it guys! :) 

2 Replies

  • rocky09's avatar
    rocky09
    Icon for Solution Sage rankSolution Sage

    Anonymous

    Are you trying to get Summarized data along with the Calculation.

    Please post some sample data and the results what you are looking for.

  • Anonymous's avatar
    Anonymous
    Not applicable

    I was able to accomplish what I was looking to do by creating a calculated column rather than doing it in the DAX formula. Thanks for looking at it guys! :)