Wrong totals

[Anonymous]

Hi Community!

I have made some measures and when I put them in a matrix, one of the measures total is wrong.

The "nedskrivning" measure is:

And the measure for "Grundlag", which is included in above screen dump, is: 

"Værdi" looks like : 

"The measure for "Reduktion" is: 

I hope anyone can help me

Best regards
Rune

[AlB · Accepted solution]

Hi @Anonymous 

Try this measure based on the one you already have:

Nedskrivning TOT =
SUMX ( DISTINCT ( Table1[Kuranskode ny] ), [Nedskrivning] )

This assumes you want to add up the rows. If not, change the iterator.

It'd be better if you show the pieces of code in plain text (using the </> button to instert them without losing the formatting) rather than on screen captures

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

Thanks, it worked perfecly!

[amitchandak]

@Anonymous , Try like measure like and check

sumx(values(Table[kuranskodeny]), [nedskrivning])

refer : https://www.youtube.com/watch?v=ufHOOLdi_jk