Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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. ☕
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |