Measure in slicer

[Earkkaperk]

Hi guys,

I have an issue when I try to create calculated column as column cannot be pushed to remote data source.

So I decide to do with measure instead.

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

This to have AlarmDesc which is from AlarmDesc table lookup by date

Then I created another measure here

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

It works well with my table but I want this to be a slicer also.

As the measure cannot be put in slicer. So I'm stuck here.

Is there any workarounds to make this works?

I have tried many ways from here but it's not working as expected.

[Anonymous · Accepted solution]

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.

[amitchandak]

@Earkkaperk , For the measure slicer you have to use Segmentation

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q

Power BI ABC Analysis using Window function, Dynamic Segmentation: https://youtu.be/A8mQND2xSR4