SUM of VALUE based on SELECTED VALUES in one table.

[Joranger]

Hi everyone!

First off, Im very new at using DAX. 

I have an table with some prices on products that I want an measure to sumarize based on what I select in said table. 

Thus far I have this:

Total = SUMX(VALUES(_liste[Pris]), _liste[Pris])

Problem with this is when two products have the same price, it won't sum the two prices.

Thanks for any help! 

[Adescrit · Accepted solution]

Hi @Joranger 

If you want to some all of the prices, regardless of whether they are duplicate values or not, perhaps you can use a simple SUM rather than SUMX?

 SUM( _liste[Pris] )

[Joranger]

Oh dear God... Yup, that did it. Thank you so much!

[AjithPrasath]

@Joranger ,

  Can you try using disitinct in your dax query?

Total = SUMX(DISTINCT(_liste[Pris]), _liste[Pris])

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍