Filter won't "fold out" - cant set filter value

[BCGR]

Hi.

I am having a wierd error trying to create a dynamic Top N filter.

I have two tables, one with [Company Name] and one with [Operating Income]. I would like to filter the Top N companies with a slider on the Dashboard.

To achieve this, I have created a Numeric Range parameter, that I use for setting the value of N, then I have the following measure formula for evaluating each company.
 

RankMeasure = RANKX(ALL('dw dimBRREGEnheter'[Company Name]),SUMX(RELATEDTABLE('dw factBRREGRegnskapsdata'),[Operating Income]),,DESC) <= 'TopN'[TopN Value]

This evaluates to TRUE/FALSE and it works great, as one can see in the table.

However, when I try to add this measure (RankMeasure) to the filters, I cannot "fold out" the filter to set it to TRUE.

I cant set the value of it.  I tried adding it to a slicer, but I cant, it won't add itself to the slicer.

I assume that the problem is in the filter cannot evaluate the possible values of the measure when it is in a filter/slicer.

I followed a Youtube video, where the guy does exactly this, except he doesn't use a Numeric Range parameter and it works for him.

Does anyone know what is going on here?

[BCGR]

That worked! Thanks!

Is that a general restriction? That filter fields can't be True/False?

[lbendlin]

Some say restriction, some say bug. Measures as visual filters work in mysterious ways.

[lbendlin · Accepted solution]

change the measure result from True/False to 1/0