Forum Discussion

kemaley's avatar
kemaley
Frequent Visitor
2 years ago
Solved

GenerateSeries Function Cannot Be Blank Error

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[MyYea...
Need Help
  • DataInsights's avatar
    DataInsights
    2 years ago

    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/ 

kemaley's avatar
kemaley
Frequent Visitor
2 years ago

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's avatar
DataInsights
Super User
2 years ago

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/