
1. Re: Elevating LOD Exclude above Dimension Filters
Bill Lyons Feb 23, 2016 8:16 PM (in response to Santiago Perez)1 of 1 people found this helpfulOne way that might work is to "demote" the Dimension filter to a Measure filter. This can be done via a calculated field such as CASE [Company] WHEN 'A' THEN 1 WHEN 'B' THEN 2 ... END. You can combine this with a Parameter to translate the number into text for users. The downside of that is that you can only select one value at a time.
You could further "demote" it to a Table Calc filter via the LOOKUP() function.
Have you tried a Table Calc instead of LOD?
Lacking those, I think you are going to need to use FIXED.

2. Re: Elevating LOD Exclude above Dimension Filters
Bora Beran Feb 23, 2016 9:06 PM (in response to Santiago Perez)1 of 1 people found this helpfulIf you want to do RANK which is a table calculation you need all those data points in your sheet.
The trick is to use a filter that applies after table calculations compute which is a table calc filter.
Using what metric, are you filtering down to a single company?

3. Re: Elevating LOD Exclude above Dimension Filters
Santiago Perez Feb 29, 2016 8:08 AM (in response to Santiago Perez)lookup(Dimension,0) was the breakthrough I needed, as it allows me to create a filter that is applied after table calculations. Thank you Bill.

4. Re: Elevating LOD Exclude above Dimension Filters
Bill Lyons Feb 29, 2016 8:47 AM (in response to Santiago Perez)Happy to help