Last 12 Months Graph not working for DIVIDE - Please Help

[Anonymous]

Im currently trying to create a CurrentMonthTotal and a Last12MonthsTotals Graph that look like the image below.:

I have 4 values that I use to calculate this number:  

_M_LocationID = DISTINCTCOUNT(gmb_reviews[location_id])

_M_ReviewID = DISTINCTCOUNT(gmb_reviews[review_id])

_M_Avg#ReviewsByLocation = DIVIDE([_M_ReviewID],[_M_LocationID])

_M_Avg#ReviewsByLocation | Last 12 Months =

VAR MaxDate = MAX('DimDate'[FullDateAlternateKey])

VAR MaxDate_6MonthsAgo = EOMONTH(MaxDate, -13)

VAR Result =

IF(

HASONEVALUE('Presentation Calendar'[YYYYMM]) &&

MAX('Presentation Calendar'[FullDateAlternateKey]) <= MaxDate &&

MIN('Presentation Calendar'[FullDateAlternateKey]) > MaxDate_6MonthsAgo,

CALCULATE(

[_M_Avg#ReviewsByLocation],

FILTER(ALL(DimDate[Month],DimDate[Year],DimDate[YYYYMM]),

DimDate[Month] = VALUES('Presentation Calendar'[Month]) &&

DimDate[Year] = VALUES('Presentation Calendar'[Year]))

),

BLANK()

)

RETURN

Result

I am using the _M_Avg#ReviewsByLocation measure to calculate the CurrentMonthTotal and the _M_Avg#ReviewsByLocation | Last 12 Months for the last 12 months.  It's for some reason adding them all and showing me the same total across the board.  This is what the underlying data looks like.:

_M_Avg#ReviewsByLocation	_M_LocationID	_M_ReviewID	Year	Month
1	1	1	2019	January
1	1	1	2019	February
1	1	1	2019	March
1	2	2	2020	January
1	2	2	2020	September
1.2	9	11	2020	October
1.3	12	16	2020	November
1	7	7	2020	December
1	5	5	2021	January
1	4	4	2021	February
1.3	6	8	2021	March
1.3	7	9	2021	April
1.3	8	10	2021	May
1.2	10	12	2021	June
1.3	12	16	2021	July
1.4	12	17	2021	August
1	2	2	2021	September

I have 2 parameters for month and year which the CurrentMonthTotal should show for the month/year picked and the Last 12 Month total should show from that year/month back 12 months.  The numbers should be in the 1.2, 1.5, 1.7 per month, but as you can see its showing me the total for all.  I am not sure how to fix.  

This is a sample of the expected result (with the right numbers shown in the table above).  Notice every month has it's own different value and not the same for evey month as the current graph shows (very top)

Any help is much appreciated.  Thank you!

[Ashish_Mathur]

Hi,

It is best to show some data (in a format that can be pasted in an MS Excel file) and the expected result in a Table format.

[Anonymous]

Here you go .. thank you.

_M_Avg#ReviewsByLocation	_M_LocationID	_M_ReviewID	Year	Month
1	1	1	2019	January
1	1	1	2019	February
1	1	1	2019	March
1	2	2	2020	January
1	2	2	2020	September
1.2	9	11	2020	October
1.3	12	16	2020	November
1	7	7	2020	December
1	5	5	2021	January
1	4	4	2021	February
1.3	6	8	2021	March
1.3	7	9	2021	April
1.3	8	10	2021	May
1.2	10	12	2021	June
1.3	12	16	2021	July
1.4	12	17	2021	August
1	2	2	2021	September

[Ashish_Mathur]

Hi,

Please also show the expected result (as requested in the previous message).