Percentage Value as moving average development

[Applicable88]

Hello,

I have a division of two values which are summarized as a Measure. I use this measure in a barchart where I can see monthly  percentage value of it. 

What I now want to display is a 180 days moving average (6 Month) line within this barchart :

Moving Average =

Var Calc =

CALCULATE(COUNTX(KeyMeasures,[Measure in Percent])/6, DATESINPERIOD(Mastercalendar[Date].[Date],LASTDATE(Mastercalendar[Date].[Date]),-6,MONTH),ALLEXCEPT('KeyMeasures',KeyMeasures[Measure in Percent]))

RETURN

IF(MAX(Mastercalendar[Date].[Date])>TODAY(),BLANK(),Calc)

The dimension for the bar chart is a date format.

it worked out pretty well for another report. But now I get the error: "Canot find Measure in Percent among KeyMeasure or possible cannot be used"

I guess the problem is that its a scalar value, so I did a calculated calumn as well,  of  calculated column= valueA/valueB. 

Instead of the measure I put the column in. No error. But now I get no values at all. How to work with percentage ? Is there a easier way to write a 180 days moving average with the percentage value?

Thank you very much in advance. 

Best. 

[amitchandak · Accepted solution]

@Applicable88 , Try a measure like

CALCULATE(COUNTX(values(Mastercalendar[Date]),[Measure in Percent])/6, DATESINPERIOD(Mastercalendar[Date],LASTDATE(Mastercalendar[Date].[Date]),-6,MONTH))

[Applicable88]

Hello @amitchandak,

thanks so much, but I can't display it. the barchart is always showing me no values, no graph for the moving average and I don't know why.

When I use a table to visualize this first I have a value MA Value in every month. Switching back to the chart there is only a bar chart with the absolute monthly value but no graph. I tried also other bar chat visuals with no success. What might be the problem here?