cancel
Showing results for
Did you mean:
Super User

## Re: Bill of Material Totals

Unfortunately I don't understand the desired aggregation logic, so please give some samples of the desired mathematical operations behind it.

Proud to be a Datanaut!

Imke Feldmann

Regular Visitor

## Re: Bill of Material Totals

hi imke,

D come at two places in my last reply. onetime as in the parent chain of A and another time in the parent chain of E.

Under the chain of A the total for D is 1x5x3x10=150. Under the chian  of E the total for D is 2x1x5=10. so total for D is 150+10=160

Super User

## Re: Bill of Material Totals

Thanks, that's a step further, but I have the impression, that I still don't see the full picture.

So please give a representative example of your source data and the full desired result.

Please also explain what role exactly the levels play and include data in your sample that show their role.

Proud to be a Datanaut!

Imke Feldmann

Regular Visitor

## Re: Bill of Material Totals

Hi Imke

here is an example. The levels are used to create a parent child hierarchy. Lower number level parts are parents of those with a higher level number. i hope the example makes it clear.

Member

## Re: Bill of Material Totals

@hk2018086

can you explain one more time... if possible...

i have modified your data, as per below table.. how come your result...

 Level Part qty 1 A 1 2 B 5 3 C 3 4 D 2 2 E 3 3 F 3 3 D 5 2 C 2 1 B 2

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 131 members 1,807 guests
Recent signins: