I am having a table Order with the column product and total price
I am having product column as Enumlist with ref -Product table
Total Price column with data type Price
I am using expression
ANY(SELECT(Product[Price], IN([ID],[_THISROW].[Product ID])))
Its resulting only the price of one product which I select in Product Column
I need the sum of the price which I select multiple Products in the Product Column -enum list
Maybe like this
SUM(SELECT(Product[Price], IN([ID],[_THISROW].[Product ID])))
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |