Remove partial filter

Hi, Thulasiram 

The error indicates that there is a type mismatch between the SelectedMonth and Date[MonthNumber] values. To fix this, we should ensure both values are of the same type. If one is a text and the other is an integer, we can use the VALUE function to convert the text to a number or the FORMAT function to convert the number to text.

Here's the updated DAX measure:

SalesUpToSelectedMonth = 
VAR SelectedMonth = VALUE(MAX('Date'[Month])) -- Ensure month is treated as a number
VAR SelectedYear = MAX('Date'[Fiscal Year])
RETURN
CALCULATE(
    SUM('Sales'[SalesAmount]),
    FILTER(
        ALL('Date'),
        'Date'[Fiscal Year] <= SelectedYear &&
        (
            'Date'[Fiscal Year] < SelectedYear ||
            VALUE('Date'[MonthNumber]) <= SelectedMonth
        )
    )
)

If this post helps, then please consider Accept it as the solution and kudos to this post to help the other members find it more quickly