How to add the lines and not the total average of an 'Increase %' column?

[AliceW]

Hi everyone,

Sorry, it's a confusing topic, but hear me out.

I have two tables, and one includes an 'Increase %' column, one per each 'Category'.

Say

Category: Fruits

Increase%: 5%

It's connected (one-to-many) with another one.

Second table:

Category: Fruits

Good: Apples

Amount: 100

Basically, I created a sumx(Amount) measure. Then another one for Increase%, but that one is using AVG?

It works fine for the lines (Apples are 100 * 5%), but the total is just wrong. It's calculating the AVG, and it should just add the lines.

Any chance of a solution, please?

Alice

[AliceW]

Yes, thank you. I went with the column.

The cherry on the cake to solve my matrix problem was to create a MEASURE, Increase = Divide(Amount/Total), and this way a matrix will have the proper totals.

[amitchandak · Accepted solution]

@AliceW ,Create a new column using related on use that in measure

New column in Table 2

New column Increase  = related(First[Increase%]) * [Amount])

new measure =

Measure Increase  =Sumx(Second,  related(First[Increase%]) * [Amount])