Divide column by measure

[Anonymous]

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.

[FreemanZ]

hi @Anonymous 

how many tables do you have and how are they related?

[Anonymous]

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.

[FreemanZ · Accepted solution]

hi @Anonymous 

try to plot the Month column from cost table and a measure like this:

AvgCost =

DIVIDE(

    SUM(Cost[Cost]),

    [Total Tickets Closed]

)

[Anonymous]

Apologies for the delay, I have been on holiday. Worked perfectly, many thanks.

[FreemanZ]

no problem at all. hope you enjoyed and now fully charged to charge ahead. ☕