Reply
Frequent Visitor
Posts: 3
Registered: ‎06-22-2017
Accepted Solution

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.

 

 

Filter R12 EBIT measure with master slicer table.JPG 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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.

View solution in original post


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.

 

 

Filter R12 EBIT measure with master slicer table.JPG 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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!