Know value of filter to apply in calculate column

[Rayito169]

Hello,

My name is Javi and I am starting to use power Bi in my company.

I have a doubt with apply a value of filter in a if sentence.

This is my filter and I need to know its text value ( LRP1,LRP2,..) to use in a if sentence.

In this moment, I have it:

And I use it in a if:

It is a If sentence to calculate difference sums depends on FILTRO LRP value but I have an error.

Could I help me?

Many thanks.

[v-haibl-msft · Accepted solution]

@Rayito169

You can try to create measures with following formulas.

FILTRO_LRP =
    IF ( HASONEVALUE ( Tipos[nombre] ), VALUES ( Tipos[nombre] ) )

LRP1 =
IF ( [FILTRO_LRP] = "LRP1", 1, 2 )

Best Regards,

Herbert

[Rayito169]

It´s work. Thank you very much to all.

[BhaveshPatel]

YOU SHOULD USE "ALLSELECTED" or "HASONEVALUE" function to get the value of slicer.

[Rayito169]

I am trying this but it does not work