-3 Mins. I need help with a DAX measurement.

[Syndicate_Admin]

Good morning community!
I need help with one thing that I know is very simple, but I need advice from someone with more experience.
I have the following data modeling which is pretty simple. Relaciones de las tablasTable relationships

The calendar table has the dates, the product table has product catalog information, the tickets table has billing and pricing information.

The objective is to calculate the turnover that a series of new products have had on a specific day.

These products are the ones that are in the New January products table.
In the products table there are +5,000,000 products. in the January novelty products table there are only 50, but those 50 products are in turn in the products table.
The EAN field in the product table is not unique, there can be multiple products that have the same EAN.
The EAN field in the January New Products table if they are unique values

I make a ratio of 1 to N from Novelty Products January to Product.

The doubt comes next, when I make a table visual with the EAN fields (for New Products January) and invoicing.
Billed Year = SUM(tickets[amount])

The EAN and product name are from the New January products table.
Row-level billing is correct. In the table you can see the 50 novelty products and the invoiced amount that should be approximately € 1100. The problem is that the total returns 250k, and that value corresponds to the sales of the +5,000,000 products and not to the 50 I need.

At this point I don't know where else to go next, I tried to make a measure that will evaluate the turnover only of the products that have the same EAN of the table New products January:

But when I want to represent it in the table I get the following error:

If anyone can think of a solution, I would appreciate the comment.
Thank you very much in advance 😄

[Syndicate_Admin · Accepted solution]

I have already found the solution, it is corrected using the following formula:

Facturado Enero25 =
SUMX ( VALUES ( 'Productos novedad enero'[EAN] ), [Facturado Año] )