wrong total of measure

[Tomek1982]

Calculation of a total for measures seems to be extensively commented, however I can not solve my issue.
There is following table:

where:

Wartość jednostek = MAX('Table1'[wycena]) * 'Table2'[Running ilosc jednostek]

I understand that this way Total of "Wartosc jednostek" (104318) = Max of wycena (592) * Sum of "Running ilosc jednostek" (176), but this is not what I expect.

How can I calculate Total value to be arround 33k?

[v-zhangti · Accepted solution]

Hi, @Tomek1982 

You can try the following methods.

Measure =
IF (
    HASONEVALUE ( Table1[Column1] ),
    [Wartość jednostek],
    SUMX ( Table1, [Wartość jednostek] )
)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[latimeria]

Hi @Tomek1982 ,

You need to make a different calculation at total level.

Try something like this:

If (isinscope('Table1'[Column1], // unique value at line level
   MAX('Table1'[wycena]) * 'Table2'[Running ilosc jednostek],
   calculate (total level)
)