Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning,
I have a Filter Pane related to the year with this expression:
=[CREATION_DATE.autoCalendar.Year]
Then I have measure in a KPI object with the "1" identifier that currently block all user selection in filter panes, like this:
Count({1<[CREATION_DATE.autoCalendar.Year]={2019}, [TABLE1.STATE]={'TEST,'QUALITY'}, SCHEDULING = {'ACTIVE'} >}[TABLE1.NAME])
I just want to block user selection with filter pane related to the year (so [CREATION_DATE.autoCalendar.Year]={2019} should remain fixed) but leaving selection for any other filter pane. In other words, I don't want to modify the KPI with the selection of the year, but only with others selections)
thanks in advance.
Just don't use 1 modifier and use $ MODIFIER.
with $ modifier and restricting year to 2019 in set analysis will help to solve ur problem
Hi, thanks for your response.
With the $ doesn't work as supposed, because the FIlter Pane is continuing to affect the KPI Measure
Any other solution to solve the problem?