Filter with an if statement embedded causing performance issue
I have a status in the table and I want to show fiscal years only associated with that status in the filters.
So filter is..If(status =sold, fiscal year)
The filter take a few minutes to render..
I have tried to create a concatenated table in the load script that has a list of filters but that doesn't seem practical as I have to list each filter..
So if I have more than 1 filter then I have to include them all in the distinct, also have to join the filters to the existing data model so I will have to create an alias ..might work..thanks
