Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to Solution.
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/
Proud to be a Super User!
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 )
Proud to be a Super User!
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).
https://dax.guide/selectedvalue/
Proud to be a Super User!
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
187 | |
94 | |
67 | |
63 | |
54 |