Forum Discussion
Exclude A Matrix Column From Interacting With A Date Slider
I discovered the solution to the issue and it was ridiculously simple. I was using the wrong source table for my date slider. The REMOVEFILTERS does work now. This was definitely a facepalm moment on my part. Thank you Ritaf1983 and Anonymous for attempting to help. Should have had more coffee before posting this one.
Hi rbowen
Following your description, I tested it using simple data and the measure works well in the matrix.
As Ritaf1983 mentioned, please provide some sample data and explain your matrix construction process in as much detail as possible (DAX formulas for other metrics used in the matrix, other table fields that may be used, relationships between tables, etc.). This will allow us to clarify the cause of the problem as soon as possible and make suggestions.
YTDQtyStatic = CALCULATE(SUM('Sales'[CurrentFYQty]), REMOVEFILTERS('Date'[Calendar Date]))
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jarvis -
Does your value stay static if you move the right hand side of the date slider to the left?