Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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.
1 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]

)

View solution in original post

5 REPLIES 5
FreemanZ
Super User
Super User

hi @Anonymous 

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

Anonymous
Not applicable

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.

 

botty_0-1674819964757.png

 

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
Not applicable

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. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors