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:
Go to Solution.
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] )
View solution in original post
Oh dear God... Yup, that did it. Thank you so much!
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 👍
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.