Filtering Data

[Anonymous]

I want to add a calculated column where I have a filter on. This is in the sales targets table. How can I add a filter which filters on city with the ordval from the sales table?  I want to sum the ordval bases on the city from the sales targets table and the month. How do I do that? I figured out that calculating just the cities would need this formula: 

Sales 2016 = CALCULATE(SUM(Sales[ordval]))

[TomMartens]

Hey,

please create a pbix file that contains some sample data, and the reflects your data model, upload the file to ondrive or dropbox and share the link.

Regards,

Tom

[Anonymous]

Hi @TomMartens, this is my file https://www.dropbox.com/s/6d9phkxtrdnoz9p/Sales.pbix?dl=0

[v-lili6-msft · Accepted solution]

HI, @Anonymous

After my test, you could try this way:

Step1:

Add a Month NO column for sales targets table, because Month column in sales targets table can't match with Month column in sales table.

Step2:

Change the cross filter direction to Both 

Step3:

Use this formula to create a calculate column

Column = CALCULATE(SUM(Sales[ordval]),FILTER(Sales,Sales[Month]='Sales Targets'[Month NO]))+0

Best Regards,

Lin