Forum Discussion
How to ignore first value shown in line graph when using a moving range measure
Hi Ahmedx , thank you for your reply.
I tried your suggested measure. It did not seem to work. When I added this measure to the line graph visual, it seems to be calculating the Sum of Mean Value rather than Moving Range.
Here is the line graph with your suggested Measure:
Which is the same as my Sum of Mean Value line graph:
I tried modifying my Moving Range Measure to incorporate your suggested Measure:
But this did not work, it is still showing that first value:
Super Useryou don’t need to put everything in one measure
need to be written separately as two measures
When I try your measure as a separate measure, it does not give the desired output:
The Moving Range line is what my desired output is but with the first value being ignored.
Your suggested Measure is returning the Sum of Mean Value that the Moving Range Measure is built off of.- Ahmedx
pls try this
if this doesn't help then share the file
Moving Range = VAR _MinDate = MINX ( ALLSELECTED ( 'Data' ), 'Data'[Created On] ) VAR EarlierTime = CALCULATE ( MAX ( 'Data'[Created On] ), FILTER ( ALLSELECTED ( 'Data'[Created On] ), 'Data'[Created On] < SELECTEDVALUE ( 'Data'[Created On] ) && 'Data'[Created On] > _MinDate ) ) VAR EarlierMeasureValue = CALCULATE ( [Sum of Mean Value], 'Data'[Created On] = EarlierTime ) VAR Moving_Range = ABS ( EarlierMeasureValue - [Sum of Mean Value] ) RETURN Moving_RangeI created an example file but do not see an option to attach a pbix file.