GenerateSeries Function Cannot Be Blank Error

[kemaley]

Hello,

My code for parameter is below down

Parameter Month = 
VAR MonthMax =

CALCULATE(
MAX(Sales[MyMonth]),
FILTER(
Sales,
Sales[MyMonth]>=1 && Sales[MyMonth]<=12
)
,

Sales[MyYear]=SELECTEDVALUE('Parameter MyYear'[Parameter MyYear])
)
RETURN

GENERATESERIES(1,MonthMax)

  It raises "The arguments in GenerateSeries function cannot be blank" error.

However, when I put the MonthMax variable code as a separate measure on a card, I get the correct result. What could be the problem?

Thanks in advance.

[DataInsights]

@kemaley,

Calculated tables (and calculated columns) are unable to recognize user filters. Measures, however, do recognize user filters. On a side note, it's recommended to use individual filter arguments instead of "&&":

Parameter Month =
VAR MonthMax =
    CALCULATE (
        MAX ( Sales[MyMonth] ),
        Sales[MyMonth] >= 1,
        Sales[MyMonth] <= 12,
        Sales[MyYear] = SELECTEDVALUE ( 'Parameter MyYear'[Parameter MyYear] )
    )
RETURN
    GENERATESERIES ( 1, MonthMax )

[kemaley]

The problem is in the following part of the code

SELECTEDVALUE ( 'Parameter MyYear'[Parameter MyYear] )

When I change this part of the code to 2024, it works. But if I use parameter, it causes the same error.
There is no problem with other measures. But this GenerateSeries function does not accept the parameter value.

[DataInsights · Accepted solution]

@kemaley,

The reason is that 2024 is a single value, but the SELECTEDVALUE expression returns BLANK since there is more than one value in 'Parameter MyYear'[Parameter MyYear]. Even though a user may have selected 2024, calculated tables don't recognize user selections (e.g., slicer/filter).

https://dax.guide/selectedvalue/