Goals without average

KrisB2019 ,

Here's what I came up with. You have a Sales and Goal table , which will be your Fact Tables.  Created a DimSalesPerson which is just a one-column ( could be more ) table of the unique sales people.  Also need a dedicated Calendar table. I added that with a small function.  All which can bee seen in Power Query.  Also, there's another table called PivotedGoal, where I show how to transform the table you get from excel into one that works so much better with DAX and PBI.  Also you can see in the applied steps in the attached file below.  But here's the data model:

So we will use Dates from the new DimCalendar table and Salesperson from the new DimSalesPerson table for our filters ( row, columns, slicers, ect.  

We start with two base measurs. Total of Sales and Total of Goals:

Total Sales = SUM ( FactSales[Amount] )

Total Goal = SUM( FactGoal[Goal] )

That gives us the total of sales for each day and then the Monthly goal on the 1st of the month.  The FactGoal table needed a date (not just a month name) so I chose the 1st, which makes the most sense if these are monthly figures.  

Then we are interested in what the running month-to-date figure is for sales ( so we can see where we are in conjunction with the goal):

Total Sales MTD = 
IF( 
    NOT( 
        ISBLANK( [Total Sales])
),
TOTALMTD( [Total Sales], DimCalendar[Date])
)

all that says if I have a total sales figure, give me the total from that day all the way back to beginning of the month. If there are no sales, I dont want anything.

But since we have daily sales, we need that monthly goal figure available every day so we can compare.  This will give the current month's goals in each day we have sales ( you wouldnt actually put this on a table since it will just be repeating, but we need it in future calculations.

Total Monthly Goal every day = 
IF( 
    NOT( 
        ISBLANK( [Total Sales]))
    ,
CALCULATE( [Total Goal], ALL( DimCalendar) )
)

 Then the last measure is the take the total of sales month-to-date and divide that out by the monthly goal:

% of Goal = 
IF(
    NOT( 
        ISBLANK( [Total Sales])
        ),    
    DIVIDE( [Total Sales MTD], [Total Monthly Goal every day])
)

and here's the final table:

It can be a complex subject and I just scratched the surface here, but I hope it gets you started in the correct direction.

Here's the PBIX file:

https://1drv.ms/u/s!Amqd8ArUSwDS0RrdxZ_ztcJ5MyV-