Trouble with my Sum on a Card

[MikeyB]

Hi Team,

I think I am missing something obvious here - sorry for the novice question.

I have 1 job with 2 invoices. The two invoices have multiple Stockcodes on them.

The job has a Received Date and each invoice has a Invoice Created Date.

I want to know how long ON AVERAGE it takes to invoice a job.

Therefore I created a new column in the table called 'Days to Invoice' which calculates the difference between the Invoice Created Date and the Job Received Date.

This all looks good in the table.

However, when I create a CARD to give me the total Days to invoice BY INVOICE it is adding up all of the rows. Likewise the Average is the average over all the rows.

I guess I need to add something to my Measure to correct it.

Please help! 🙂

Screenshot below...

[tamerj1 · Accepted solution]

Hi @MikeyB 

pleaae try

Sum =
SUMX (
SUMMARIZE (
'Table',
'Table'[Job No],
'Table'[Invoice No],
"@Days", MAX ( 'Table'[Days to Invoice] )
),
[@Days]
)

Average =
AVERAGEX (
SUMMARIZE (
'Table',
'Table'[Job No],
'Table'[Invoice No],
"@Days", MAX ( 'Table'[Days to Invoice] )
),
[@Days]
)

[MikeyB]

Thanks @tamerj1 That worked perfectly. Cheers.