Strange problems in calculating totals

[marsclone]

Hello,

I'm facing strange problems when calculating total values.

I have a measure which calculate the row values right, but the total is null.

When i add a new measure, the total value is right, but the row values are null.

Another measure, right row values but a strange total value

And so on...

I don't see what is going wrong? I hope you can help me!

Measures are

Productmix1 = ([Tonnen CY %]-[Tonnen LY %])*[Tonnen CY All]*[Prijs LY]

Row values are right!

Productmix2 = SUMX(values(Artikelen[Artikelgroep]);[Productmix1])

Productmix effect = If(hasonefilter(Artikelen[Artikelgroep]);[productmix1];sumx(Artikelen;[Productmix1]))

Productmix3 = SUMX( SUMMARIZE(values(Artikelen[Artikelgroep]);[Artikelgroep];"ABCD";[Productmix1]);[ABCD])

[Ashish_Mathur · Accepted solution]

Hi,

Does this measure work?

=IF(HASONEVALUE(Artikelen[Artikelgroep]),[ProductMix1],SUMX(SUMMARIZE(VALUES(Artikelen[Artikelgroep]),Artikelen[Artikelgroep],"ABCD",[ProductMix1]),[ABCD]))

[marsclone]

Hi @Ashish_Mathur 

Unbelievable! This one works! Really thank you!

Nevertheless, i find it really hard to find the right way how Power Bi calculates the different totals.

Thank you again!

Kind regards Marcel

[Ashish_Mathur]

You are welcome.

[mwegener]

Hi @marsclone ,

could you post your calculation of the measures.

[Tonnen CY %]

[Tonnen LY %]

[Tonnen CY All]

[Prijs LY]

Please give Kudos for support.