For specific value of one column i need to filter other column, without affecting rest of the table

[Anonymous]

Hello Iooking for help to filter one of my table only for specific value

For instance if my table is like this:

columnA	columnB	columnC
1	rt	1a
2	ft	1a
3	gt	1a
4	rt	2a
5	gt	2a
6	gt	3a
7	ft	2a
8	ft	3a
9	rt	3a
10	abc	1a
11	dfg	2a
12	bgj	2a
13	fhi	4a
14	vklm	1a
15	eww	3a

now I need to take put this condition
when columnB has (rt, ft, gt) then filter columnC = 1a, without affecting other rows,

Output should be like this

columnA	columnB	columnC
1	rt	1a
2	ft	1a
3	gt	1a
10	abc	1a
11	dfg	2a
12	bgj	2a
13	fhi	4a
14	vklm	1a
15	eww	3a

[jaideepnema · Accepted solution]

Hi @Anonymous ,
Create a Calculated Column as shown below:

Filter = IF('Table'[columnB] in {"rt","gt","ft"},IF('Table'[columnC]="1a",TRUE(),FALSE()),TRUE())

Now use this column to apply a visual level filter to get the required output:

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀