cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Post Prodigy

## SUMX Multiply per Row - Wrong Total

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?

3 REPLIES 3
Solution Sage

Hi,

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

Regards

Impactful Individual

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.

Post Prodigy

@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.