## Desktop

Frequent Visitor
Posts: 3
Registered: ‎06-22-2017

# Filter R12 EBIT measure with master slicer table

In my example I have calculated a [R12 EBIT %] measure for a number of stores - returning a percentage ranging from -51% to +34%.

I would like to categorize these by a simple threshold table ([MasterSlicer]) looking something like this:

```Label		Pct			Order
OK		0	         	1
Neutral		0,1			2
Good		0,17		        3```

I can't seem to figure the correct way to do it. Any suggestions?

Thanks,

Alexander

Accepted Solutions
Community Support Team
Posts: 7,645
Registered: ‎05-02-2017

## Re: Filter R12 EBIT measure with master slicer table

Hi @alexandert,

Please use it as a measure. And "R12 EBIT %" is a measure that already exist.

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

All Replies
Community Support Team
Posts: 7,645
Registered: ‎05-02-2017

## Re: Filter R12 EBIT measure with master slicer table

@alexandert

Hi Alexander,

If we can find out the max "Pct", we can find out the "Label". Maybe the measure looks like this:

```Label_Measure =
VAR MaxPct =
CALCULATE (
MAX ( 'Table1'[Pct] ),
FILTER ( 'Table1', Table1[Pct] <= [R12 EBIT %] )
)
RETURN
IF (
ISBLANK ( MaxPct ),
"NA",
CALCULATE ( VALUES ( 'Table1'[Label] ), 'Table1'[Pct] = MaxPct )
)```

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 3
Registered: ‎06-22-2017

## Re: Filter R12 EBIT measure with master slicer table

Thanks Dale,

However, I get the "CALCULATE has been used in a True/False expression....." error message. Not sure what to do, ideas?

Thanks,

Alex

Community Support Team
Posts: 7,645
Registered: ‎05-02-2017

## Re: Filter R12 EBIT measure with master slicer table

Hi @alexandert,

Please use it as a measure. And "R12 EBIT %" is a measure that already exist.

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 3
Registered: ‎06-22-2017

## Re: Filter R12 EBIT measure with master slicer table

Thanks, works like a charm!