Hopefully someone can help with this one.
I have a filter in the tabular model of my query. The filter is designed to weed out certain chunks/rows of data.
I want to only apply the filter if certain other conditions are met...specifically, I have a data item (name = isAdmin) in my report's tabular model that will either be set to 'TRUE' or 'FALSE'...it is a calculation based on the data returned by the CSVIdentity
So, how do I only apply the filter when that data item is set to 'FALSE'?
As I was playing around with this, I tried this for my filter expression:
IF (isAdmin = 'FALSE') THEN ([Enrollment].[Benefit Employer Group].[Group Number]not in ('4750000','4750002','4759902','5320000','5320002','5329902','50010022','50019922','300100','50010092','50019992','50019993','50019994'))
That only gives me errors in the report.
Any assistance would be greatly appreciated.
Thanks.
Joe