Forum Discussion
How to ignore first value shown in line graph when using a moving range measure
Hi Anonymous , thank you for your response.
I tested out your solution, but ran into an issue. I believe this issue occured since my Moving Range field is a measure and not a column or calculated column.
I slightly modified the DAX measure you provided:
I tested out this measure and it seems that it is removing that first data point, but it outputting the Sum of Mean Value instead of the Moving Range.
For some additional context, there are filters implemented on the table visual for various fields. One of those filters is on the Created On field to only show a select about of data. Here is what the Created On, Sum of Mean Value, and Moving Range fields look like in a table without any filters:
So, I'm looking for a solution where the first Moving Range value will not be visible no matter what filters are selected.
- Ahmedx
Super User
pls try this
Measure = CALCULATE([Moving Range], OFFSET(1,SUMMARIZE(ALLSELECTED('Table'),'Table'[Created On]), ORDERBY('Table'[Created On])))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:
- Ahmedx
you don’t need to put everything in one measure
need to be written separately as two measures
