How to create a measure for Goal Total Amount for each Month

[SteelChampzz]

I have a table that has Goals for each month:

when I try to put this information into a line/bar chart it gives me either COUNT of SUM the amounts together, and not indiviually.

Which in turn makes the visual look like this:

 Is there a measure I can create to have the Totals for each month reflex the amount for that month?

Help is greatly appreciate!

[Greg_Deckler]

@SteelChampzz So is your visual configured with those two columns in it or are the columns coming from a different table (like a date table)? Maybe missing a relationship?

[SteelChampzz]

It's configured with just these two columns in a table, No dates are attached to the table

[Greg_Deckler]

@SteelChampzz Somethings not correct, see attached PBIX below signature.

[SteelChampzz]

The only relationship that is created is to the "Dimdate" table. "Month" relationship.

[Greg_Deckler · Accepted solution]

@SteelChampzz 100% bet that you are using Month from your DimCal table and since the cross-filter direction is not Both it is not actually filtering your goal table. Just use Month from your goal table and you're good. 

[SteelChampzz]

Greg THANK YOU!

I've been banging my head against the wall with this. You're Awesome!

[Greg_Deckler]

@SteelChampzz Happens!! 🙂