Suggest the data model for my data

rajanimaddala 

In such cases, I usually create a simple table of unique products and then link it with Product and Target. This table then will act as filter table and you can use it in your visuals and DAX.

So you will have two filter tables: Product(Unique) & Calendar/Date table

And you will have two fact tables: Performance Data and Target Data

There will be a Many-to-One relationship between fact and filter tables and then you can write your DAX suitable to your need. You can use RELATED function to filter the facts table.

Hope this should help.

Rgds,

Vivek

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