Forum Discussion
Divide column by measure
Hi, I use the following Measure to add up the totals from 4 tables.
Total Tickets Closed = [Total Changes]+[Total Incidents]+[Total Problem Records]+[Total Service Requests]
The above is from 4 individual measures, one example directly below.
Total Incidents = COUNT('SR Incidents Closed'[Number])
This gives me the total number of tickets worked on by our support teams. I can then plot those by month on a chart, all works fine.
However, I also have a column which shows the costs, and one that shows the months so I can plot the costs by month.
What I want to do though is divide those monthly costs by the number of tickets in the month to get the cost per ticket, but just can't do it. Any help would be appreciated.
hi Anonymous
try to plot the Month column from cost table and a measure like this:
AvgCost =
DIVIDE(
SUM(Cost[Cost]),
[Total Tickets Closed]
)
5 Replies
hi Anonymous
how many tables do you have and how are they related?
Hi FreemanZ There are five tables in total, one each for Incident, Change, Service Requests and Problem Records and one for Costs. They are related by Month. It's called Month in one table and Closed in the other four, but the data is all in the same format, just the column name different.
hi Anonymous
try to plot the Month column from cost table and a measure like this:
AvgCost =
DIVIDE(
SUM(Cost[Cost]),
[Total Tickets Closed]
)