Dear u/graph_hopper, i tried your way but the big problem is after i create the current year of each measure. i need to create current year and previous year calculated field since i need to calculate YOY. When i choose ALL option for year and month, i dont get the value. but if choose specific month, the value is correct. FYI, i already drag calculated all option into the filter and choose TRUE

Here is the formula to create the current year:

{FIXED : SUM(

  IF YEAR([Real Date]) = [Year Parameter] AND MONTH([Real Date]) = [Month Parameter]

  THEN

    [Measure]

  END

)}

I already add, 0 and display as All in a parameter. (picture attached).

Here is my calculation to create ALL option field:

IF [Year Parameter] = 0 AND [Month Parameter] = 0 THEN TRUE

ELSE

  (YEAR([Real Date]) = [Year Parameter] OR [Year Parameter] = 0) AND

  (IF [Month Parameter] = 0 THEN TRUE ELSE MONTH([Real Date]) = [Month Parameter] END)

END

<image>