Using slicer values in measures

[patboutot18]

Hi, 

I need to calculate the average of a performance indicator depending on a slicer value that represents a period. Let's say the user chooses period 100, I need to calculate the average of the performance indicator for periods 96,97 and 98. So I tried to extract the value of the slicer with Selected Value and then substract 2 to that measure to get the 98 I wanted, but when I add that measure into my average measure it shows blank. Although, when I write 98 manually into the formula, it works.

What have I done wrong? 

Thanks in advance. 

[Anonymous]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490