Slicer Set Value

[atat0105]

Hello everyone,

I have a column which defines each row like below.

Column =IF(V_OKM_0[Periyod]<601;""Active"";""Passive"")

then, I show percentage of ""Passive"" on a card.

Measure = CALCULATE(SUM(V_OKM_0[Pasif])/(SUM(V_OKM_0[Aktif])+SUM(V_OKM_0[Pasif])))

But I would like to have a slicer includes values of 301, 601, 901 instead of a set value like 601 in example above. Is it possible to do?

If slicer is 601,

Periyod - Column

400 - Active

700 - Passive

1000 - Passive

So, result is %66

If slicer is 901,

Periyod - Column

400 - Active

700 - Passive

1000 - Passive

So, result is %33

Thanks a lot.

[cosborn1231 · Accepted solution]

Hi Atat0105,

You will need to use a disconnected table here.

Instead of "hardcoding" the IF in your column to <601 you can pass a slicer value through.

Click "Enter data" and build a table like below/ the measure shown in the formula bar.

 

Once you do this pass that measure into the calculated column like so:

When you are using disconnected tables you allow yourself to pick what you want to slice on. Connect the tables within Power BI to filter correctly. Once you select a value from that disconnect table it will pass that value into the rest of your functions.

Hope this helps,

Christian

[Greg_Deckler]

Can you provide some sample data so that we can mock this up?