Forum Discussion
Anonymous
6 years agoNot applicable
Parameter with dynamic range
Hi,
I have a slicer populated by a GENERATESERIES:
Parameter = GENERATESERIES(1,100)This works fine, but now I want to set the max of the GENERATESERIES to this IF statement
Parameter = GENERATESERIES(1, IF(COUNT(Table[Employees]) < 100, COUNT(Table[Employees]), 100)This partly works, but it counts all the employees in my table, and isn't affected by any filters in my report. Is it possible to force the COUNT to be filtered by other filters on my report?
Kind regards
1 Reply
- parry2kSuper User
Anonymous unfortunately that is not possible, you cannot have it dynamic.