Calculate formula from different table failing

[Cyrilbrd]

Good day,
given the following tables:

sales_header
sales_item
and date_table
relationship from Sales_header and sales_item is as follows:

Date table is linked to Sales_header with the transaction_date.

I would like to diplay the sales sales_item [amounphp] per location (sales)header[location]) and only for specific locations.
te objective being to get the ratio per location.
i can get it via a table such as:

But I would like to get it via a measure inorder to display it in a card.
So far 3 locations.
I need the sales for ECOM only
I need the sales for VROC only
I need the total sales with VHO excluded.

I tried: 

Measure = CALCULATE (

[sales],

FILTER ( 'vproject sales_header', 'vproject sales_header'[location] = "ecom" ),

FILTER ( 'vproject sales_header', 'vproject sales_header'[location] = "vroc" )

with sales being 

sales = sum('vproject sales_item'[amountphp])

But not to avail.

Any idea why?

[jdbuchanan71 · Accepted solution]

@Cyrilbrd 

I think your filtering was trying to give you only lines that are ECOM and VROC both instead of either.  Try this.

Measure =
CALCULATE ( [sales], 'vproject sales_header'[location] IN { "ecom", "vroc" } )

[Greg_Deckler]

@Cyrilbrd Can you post sample data to replicate? Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.