To create the filter Switch i created a data island:
LOAD * INLINE[SWITCH YTD
However the expression is not working. I created three different measures to test it:
2. Expression for MTH values
3. Expression for YTD values
4. Expression with IF condition for MTH or YTD values
The expression in the column 4 does not work since it does not calculates the sales for all products in the table. However, column 3 shows all values and that is that I want. I suspect, the problem is coming from the data island.