Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Is it possible to get some help in creating a DAX formula for the attached problem that I came across in power bi.
I have two columns in my sample database (expense_id and amount). I have duplicate values in expense_id column and as well as duplicate values in amount column. I want to sum the amount column that has distinct values in expense_id column. I have attached a screenshot.
Really appreciate all your help. Thanks
Solved! Go to Solution.
@powerbiss not sure what you meant
@powerbiss here is the measure:
Unique Sum Amount = SUMX ( SUMMARIZE ('Table','Table'[expense_id], 'Table'[amount] ), 'Table'[amount] )
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hello good afternoon, which is what I should do if I want to add the values of more than 1 single column, as shown in the example, what should I do if I have 2 columns called amount
@powerbiss try this measure
Measure = SUMX(GROUPBY('Table','Table'[expense id],'Table'[amount]),[amount])
Hello good afternoon, which is what I should do if I want to add the values of more than 1 single column, as shown in the example, what should I do if I have 2 columns called amount
Hello @powerbiss
For some reason it is showing 285.80 in the all rows. It is not showing 250 for 17 and 35.8 for 19.
@powerbiss not sure what you meant
Hey @smpa01
That worked. had some issues with creating the relationship with the tables.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |