Forum Discussion
Calculate Cost per Product SQL
Hello Anonymous
and how are they connected? However you need to create a measure that looks like this
SUM(Product[Costs])*SUM(Sales[Units])and in the visual you put the contract n. and this measure. But as I already said, all tables need to be connected first.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hello Anonymous
use SUMX for this. Here a code that should work out for you
SUMX(YOURTABLE, db_sales.[units]*db_product.[unit_cost])Are these fields both in the same table I suppose. What you mean with filter? In case apply a Filter to your table like FILTER(YOURTABLE, [Contract]="abc")
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hi Jimmy,
Thanks for the quick reply.
Sadly they are not in the same table, each of the fields above are all in their own tables.
We have a table of contracts this is what we want to filter on (i.e we want to see the cost of X contract) , a table of products that contains how much each product costs (unit_cost) and a table of sales that contains the number of units sold (units)
Thanks
Hello Anonymous
and how are they connected? However you need to create a measure that looks like this
SUM(Product[Costs])*SUM(Sales[Units])and in the visual you put the contract n. and this measure. But as I already said, all tables need to be connected first.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy