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,
I have a problem, I hope somebody can help me.
I have two tables:
Projects
ID | Name |
1 | Project One |
2 | Project Two |
3 | Project Three |
Invoice
ID | ProjectID | Invoice Number | Amount |
1 | 1 | 1 | $100 |
2 | 2 | 2 | $200 |
3 | 3 | 2 | $200 |
As you can see the relationship is 1:*, and there are invoices that correspond to many projects, in the example Invoice number 2. Obviosly The SUM in a Table in the report will be $500 because it is adding all the entries from the Invoice table.
Is there any way to avoid it like grouping by Invoice number, because the correct SUM is only $300 because there is inly two invoices, but one of them is point to several projects.
Thanks in advance.
Thanks.
Solved! Go to Solution.
Thankl you for your help! It doesn't work, but finally I solve it as follows:
@jareyesg , Create a measure like
sumx(summarize(Projects, Projects[ID],Invoice[Invoice Number], "_1", max(Invoice[Amount])),[_1])
I assume Projects and Invoice are joined
Thankl you for your help! It doesn't work, but finally I solve it as follows:
Hi @jareyesg
You can create a reference table and group the table based on invoice to show max of invoce.
Power Query Editor --> Transform --> Group By
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Regards,
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |