Filter values base on column from other Query

Hi Yqy 
To achieve your goal you can (in PQ ).
Duplicate your table twice:
1. For Q1 - nulls :

2. For Q2 no nulls

Then you merge inner Join Q2 no nulls with your original table:

After expanding, filtering out nulls from the new column, and deleting it:

And last union is with a null copy:

them turn off the option of loading to the model those "help" tables:

Result:

Sample file here:Link to pbix 
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly