SUMX Multiply per Row - Wrong Total

[joshua1990]

Hello!

I have a simple dimensional table and a fact table.

The dimensional table has this structure:

Article	Value
A	0.9
B	0.8

Then I have a sales table that shows me the number of sales per Article.

Now I would like to multiply the column 'Value' with 'Sales'.

Before that, we need to subtract the column 'Value' with two 2. 

This functions works perfectly well on row level. But the aggregation to the total number is false.

Test = 
VAR _Factor= 2-SUM('Attribute'[Value])
RETURN
CALCULATE(SUMX('Attribute', _Factor*[Sales]))

Why is that so?

What have I missed?

[Jos_Woolley]

Hi,

Can you post a few examples with current (incorrect) results together with the desired corrections?

Regards

[Tanushree_Kapse]

Hi @joshua1990 ,

Use this measure to get the correct aggregation for your Total.
FixedTest=  SUMX(VALUES( Table[Article]), Test)

I hope this helps!

Mark this as a solution if it answers your question. Kudos are always appreciated.

Thanks.

[joshua1990]

@Tanushree_Kapse : Thanks, but it works not on row level. Maybe the result is correct for the Total, but on row level there a wrong values.