Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

  • Anonymous unfortunately that is not possible, you cannot have it dynamic.