cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Melgaardiversen
Helper I
Helper I

Wrong totals

Hi Community!

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

Melgaardiversen_0-1606806477869.png

The "nedskrivning" measure is:

Melgaardiversen_1-1606806549227.png

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

Melgaardiversen_2-1606806694420.png


"Værdi" looks like : 

Melgaardiversen_3-1606806729549.png

"The measure for "Reduktion" is: 

Melgaardiversen_4-1606806896393.png


I hope anyone can help me


Best regards
Rune



 

1 ACCEPTED SOLUTION
AlB
Super User III
Super User III

Hi @Melgaardiversen 

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 

SU18_powerbi_badge

 

View solution in original post

3 REPLIES 3
AlB
Super User III
Super User III

Hi @Melgaardiversen 

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 

SU18_powerbi_badge

 

View solution in original post

Thanks, it worked perfecly!


amitchandak
Super User IV
Super User IV

@Melgaardiversen , Try like measure like and check

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

 

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.