Can't find table for creating new measure

[djanssen]

I'm trying to create a new measure but when writing the prompt, I cannot find the table I need to reference.  

[Nathaniel_C · Accepted solution]

Hi @djanssen  ,

You won't start with a table name.  More like this. Measure = COUNTROWS(table1) When you are supplying the table or the column that is needed for the function, then you will have an opportunity to add the table.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[Anupa_Jayakody]

Coul you explain this more. I want to multiply quantity from one table and the price from the other table. Both these have the item number.

[Nathaniel_C]

Hi @Anupa_Jayakody 
Please try this:

Total Cost = MAX('Price'[Price])* MAX(Quantity[Quantity])

I created two tables Quantity and Price.  Each table has the item # column.  You will then connect the two tables in the model window by dragging one item# field to the other.

One of the tables looks like this, and the other is almost identical:

The final table looks like this, with the item#, price, quantity, and the total cost.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[djanssen]

That was very helpful, thanks for taking the time to answer this!  

[Nathaniel_C]

You are welcome!
BTW, @MattAllington  has a great book, Supercharge Power BI. I learned  a lot from working through that book.