Line and Stacked Column Chat - Show Months with no Values?

[PowerUser123]

My data is pretty simple like this:

I have a measure that counts every row that is not the USA Region: 

Measure = CALCULATE(COUNT('Table (2)'[Region]),FILTER('Table (2)','Table (2)'[Region]<>"USA"))

I want to put the data above into a Line and Stacked Column Chart. The column values should be my measure above. The column series would be region. However, I'd like a line value that shows a count of all rows by month (so do not exclude USA region).

When I do this simply, the following is the result:

It doesn't show January or April as those months only had the USA region in them. 

How can I change a measure or something to have the line values show up in January and April? I know I can right-click the calendar on the axis and click show items with no data, but that's not an ideal solution because then the following graph is the result:

Then, I would have to go and manually choose specific months/years to include which makes the visual not dynamic at all.

[V-lianl-msft]

Hi @PowerUser123 ,

Based on your description, you only need to delete the filter condition in the formula.

Measure = COUNT('Table (2)'[Region])

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@PowerUser123 , This what I tried in past for date range using date table

0 between range
Measure = var _1= SUM(Opportunity[Opportunity count]) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))