Select Row Values by column Selection

sammy02hk , you have to unpivot the first table and bring Promotion Name on rows and then you can join and filter

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

https://radacad.com/pivot-and-unpivot-with-power-bi

Hi sammy02hk,  

Did you intend to accomplish this task?

If so, utilizing a many-to-many relationship between the Article Sales and Promotion Table is an option. I am attaching the modeling view for your reference here.

Warm regards,

Riddhesh

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Riddhesh 

Thank you for your reply.

For the promotion table, is it impossible to stay in this form. 

And need to transform to his format?

Since @the Database, Article No and Promtion No are in great amounts, I try to reduce the database size.

Thank you.