Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I use the following Measure to add up the totals from 4 tables.
Solved! Go to 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]
)
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]
)
Apologies for the delay, I have been on holiday. Worked perfectly, many thanks.
no problem at all. hope you enjoyed and now fully charged to charge ahead. ☕
User | Count |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |