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
    Solution 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! :)