Forum Discussion
Getting a Distinct Avg from a separate table
I have two tables, one with number of units sold, and one with item cost. They are joined by the Item ID. The Inventory table has multiple rows with the items sold, so you would see a "Popco...
Thanks. I am new to Power BI and the community. Will share what I can.
Here is what the data looks like in the transaction table:
Here is what it looks like in the ItemsCosts Table. (Covered costs for proprietary reasons.)
Hre is what it looks like on the dahsboard:
I cannot get Cost of the particular item to match up with the item transaction. If I just pull in the "Cost" field, it reverts to count. If I try something like here where it is "Minimum" it takes the minimum cost of all items, which is zero for a Cup of Water.
Can't figure out how to get the cost for JUST the one item, Bottomless Popcorn.
Is this enought information?