Skip to main content
cancel
Showing results for
Search instead 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

Frequent Visitor

## sum of measure (average)

Hello

I have a table like the one I'm pasting below

I have to main columns I'm using qty (vtas pza) and cost

The issue i'm having is this

I created the following measures

1PROMVENTAS = AVERAGE(VENTAS[Vta Pzas])  - this is the average of units sold
2COSTOTOTAL = AVERAGE(VENTAS[COSTOPROM]) - this is the price
VTACTOTOTAL = AVERAGEX(VENTAS, VENTAS[COSTOPROM]*[1PROMVENTAS])
it want it to sum 304.37 from the 5th column,

For some reason it does not adds the results of the ids in the table if I do this for the sums instead of average it works, what am I doing wrong.  The following is the case that  works but I need averages of units and costs and then sum of totals.

VTACTOTOTAL = AVERAGEX(VENTAS, VENTAS[COSTOPROM]*[1PROMVENTAS])
VTACTOTOTAL = sumX(VENTAS, VENTAS[COSTOPROM]*[1PROMVENTAS])

Please advise
1 ACCEPTED SOLUTION
Super User

@ooctaviano , if there are more than one rows for ID, this is what you can use

VTACTOTOTAL = AVERAGEX(VENTAS, VENTAS[COSTOPROM]*[1PROMVENTAS])

VTACTOTOTAL new = sumX(values(VENTAS[ID]),[VTACTOTOTAL])

or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

2 REPLIES 2
Super User

@ooctaviano , if there are more than one rows for ID, this is what you can use

VTACTOTOTAL = AVERAGEX(VENTAS, VENTAS[COSTOPROM]*[1PROMVENTAS])

VTACTOTOTAL new = sumX(values(VENTAS[ID]),[VTACTOTOTAL])

or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Frequent Visitor

It worked great

Thanks a lot

## Helpful resources

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 - June 2024

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

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors