Measure in slicer

Hi Earkkaperk ,

It is true that putting Measure into Slicer is not supported in Power BI.

But I think you have the option of using Calculated columns, which support putting themselves into Slicer and which have similar functionality to Measure.

I create two tables as you mentioned.

Then I create two calcualted columns.

Alarm =
LOOKUPVALUE (
    'AlarmCode'[AlarmDesc],
    'AlarmCode'[DateText], MAX ( 'Fact Lineloss View'[DateText] )
)

CausalMachine_new =
IF (
    [AlarmDesc] = "4_05 Event Machine Top Closer Stop (Interlock)",
    "99.Case Sealer",
    MAX ( 'Fact Lineloss View'[CausalMachine] )
)

So you can add them into the slicer and it will give you what you want.

Best Regards

Yilong Zhou

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