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 fro...
hi Anonymous
try to plot the Month column from cost table and a measure like this:
AvgCost =
DIVIDE(
SUM(Cost[Cost]),
[Total Tickets Closed]
)
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
Super User
Super Userhi Anonymous
try to plot the Month column from cost table and a measure like this:
AvgCost =
DIVIDE(
SUM(Cost[Cost]),
[Total Tickets Closed]
)
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. ☕