cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## Trouble with my Sum on a Card

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.

Screenshot below...

1 ACCEPTED SOLUTION
Super User

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]
)

2 REPLIES 2
Super User

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]
)

New Member

Thanks @tamerj1 That worked perfectly. Cheers.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors