Forum Discussion
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?
- Anonymous7 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
- rocky09Solution 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.
- AnonymousNot 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! :)