Visual filter breaking measure calculation to (Blank)

Hello, stumped by this one.

I have a table with the following structure:

Month_Start

Goal

Example values would be:

9/1/2019

150

I then have a gauge visual that performs the following:

Value = TOTALMTD([AppointmentCount], 'Appointments'[createDate])

Where [AppointmentCount] is simply defined as SUM(Appointments[Count]) + 0

This value works fine and displays as it should.

Next i want to show a tick of where the goal is, I created a measure on my Goals table as follows:

_created_goal = LOOKUPVALUE(Goals[goal_value],Goals[MonthStart],DATE(YEAR(TODAY()), MONTH(TODAY()), 1))

This works fine and displays as it should.

Last i need to add a filter onto the result to remove certain rows from the Appointments table, I add the column from Appointments into the filters pane, and set it to values I want to include "ind_origin = Y".

This suddenly breaks my _created_goal measure, and i get a result of (Blank)

I belive it is trying to filter the goals table on that column causing it to return nothing. I can't sort out how to remove any filter on that measure, or do i have to apply that filter directly to my measure on Appointments?