Remove Specific rows in Query

[Yqy]

Hi, i have a table that look like the first one below and i would like to keep all rows with the number "1" and also keep the single entry for "C" the number "0" which look like the second table, the table below is only part of the full table, there are hunreds of different varables like "C", with only one entry and all single entry has number "0", so does anyone know how to solve this? Thanks

A	1
A	0
B	0
B	1
C	0
D	0
D	1

A	1
B	1
C	0
D	1

[Ahmedx]

pls see my video

(x)=> x[flag] = 1 or x[cat] ="C"

https://1drv.ms/v/s!AiUZ0Ws7G26RiEXNoZ4WsV-RyyHM?e=eHBHbm

[Yqy]

It seems like the site is down, I can't open the link. And also, my variables does not only have one "C" it might be hundreds of different variables with only one single entry and all single entry has a number "0"

[Ahmedx · Accepted solution]

okay, I understand you, watch another new video and if the link does not work, try watching a little later

https://1drv.ms/v/s!AiUZ0Ws7G26RiEhJ-H5yK5xREaCt?e=4au6IC
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RiEczX_BjGlZZsYMm?e=09gu9i