Sum total from enumlist

[Giuliano_Negris]

Hello everybody
consider that I am trying to learn…
I ask some pious soul to help me with this problem:
I have two tables:

• products
• sales
  from the sales table I should automatically calculate the total price of the products chosen from a ref field of type enumlist populated from the products table.
  I have tried various ways, but it fails, I used the following formula:
  SUM (SELECT (PRODUCTS [PRICE], IN (PRODUCTS [PRODUCT_ID], [_ THISROW]. [PRODUCT]), PRODUCTS [TYPE] = [_ THISROW]. [PRODUCT]))
  I’d like to use a for loop to solve, but I don’t know the syntax and don’t even know if it’s possible.
  Can anyone help me?
  Thank you

[Lynn]

Hi @Giuliano_Negrisolo
Try something like this
SUM(
SELECT(
Tablename[PriceColumn],
IN(
[CostItemsColumnName],
[_THISROW].[EnumlistColumnName]
)
)
)

[Giuliano_Negris]

Hi lynn
Thanks a lot, it works!
I also understood where I was wrong, I learned something.