Forum Discussion
GenerateSeries Function Cannot Be Blank Error
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).
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 )
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.
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).