Help with data model and DAX

Hi Anonymous ,

Thanks for your answer and sorry for not being clear. You can see attached a picture of the current model.

Each month, we put some products on promotions. We would like to measure the performance of the promotional campaign each month. For example, in April, product code 001 which is Jeans are on promotion.

Each month, I would like to see the total sales generated of the product codes on promotion. This way, I could calculate a ratio showing: Total sales from promotion / Total sales.

Example: in April, we have 3 products on promo (jeans, shirts, shoes).

Jeans: turnover of 100 of which 10 was made on promotion > promotion ratio of 10%

Shirt: turnover of 200 of which 10 was made on promotion > promotion ratio of 5%

Shoes: turnover of 500 of which 250 was made on promotion > promotion ratio of 50%

Total sales of products on promotion in April: turnover of 800 of which 270 was made on promotion > promotion ratio of 33.75%.

I hope it is more clear?