Slicer based on IF function

[Anonymous]

Hi,

I am new to Power BI world. I want to make a measure that will filter as following:

FO                      FP

Indonesia           Indonesia

India                   Indonesia

Indonesia           Thailand

Vietnam              Indonesia

Indonesia           India

I want create a measure that will retain row 1,3,5 when I select "Indonesia", other rows will not be visible. I want to create a measure using filter but not sure about the syntax.

[Thim · Accepted solution]

So just to be clear.

What you want is a slicer, that shows the lines from FP that has Indonesia?

If this is true, then you don't need to make a meassure, you can just put the FP column in a Slicer.

If you ONLY want the option to filter Indonesia you can change what options the slicer has under filter.

Hope this was what you were looking for. 🙂