filter on multiple values

[Anonymous]

I have the following measure.

2018 Sales = sumx(FILTER(Sales,Sales[Billing MM/YYYY].[Year]=2018), Sales[NSB Splits])

I now want to add a measure for 1H2018 Sales.  What's the easiest way to add the addtional filter for the month value being 1-6?

[jeroenterheerdt · Accepted solution]

Use CALCULATE:

1H2018 Sales = CALCULATE([2018 Sales], Sales[Billing mm/yyyy].[MonthNo]<=6)