Chose specific rows in a table (column) and then calculate the sum based on values in other table

[Marcusdahlberg]

Hi

I am trying to create a measure that selects specific rows in one tables colum. The table contain account numbers like 7010, 7081, 7082 etc (unique values). I would like to choose a couple of these account numbers, and then i have all sales/cost values in another table. I already have a measure that contain the cost in total.

So what i would like to do is get a total cost sum for a couple of specific rows in my "account" table based on the values in my "cost value" table. Hope you understand what i mean and maybe can help me out here. Total cost measure just based on a couple of accounts and not the entire accounts table. 

Br / marcus 

[Fowmy · Accepted solution]

@Marcusdahlberg 

Hope you have a One-to-Many relationship between the two tables. Try the following measure:

New Measure = 
CALCULATE(
  [COST MEASURE],
   Accounts[Account Number] IN {7010,7081,7082}
) 

[Marcusdahlberg]

Worked as a charm - thank you very much 🙂