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.
Hello guys!
Here is my case:
I have a table with all shipments for a month ([EAN], [Amount], [Price], etc), so the column values are NOT distinct (unique).
So I have a measure that calculates the SUM of ALL shipments for the month.
But from now I also have a table with target values for every EAN I sell ([EAN], [Total Target For The Month]). The problem is that I dont have a target for every EAN I sell. So I want to see the sales of only those products, that have a target in a table. How can I do it?
Here is my dataset relationships:
Thanks in advance!
Hi em6jq65,
Could you share some sample data and clarify more details about your requirement?
Regards,
Jimmy Tao
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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |