Create a new column filtering values from column A and retrieve the correspondent value from columnB

If your table is called sample, the following calculated column will work.

 

EDIT: Not sure of your requirement. You might need to change the 7th line below to <> CurrentProduct.

If that isn't right either, be clearer on your expected result please with some sample output.

 

Total Values = 
VAR CurrentProduct = 'Sample'[Product]
RETURN
SUMX(
    FILTER(
        ALL('Sample'),
        'Sample'[Product] = CurrentProduct
    ),
    'Sample'[Value]
)

 

Hi MigWare ,

 

I am not very clear what you want. Some possible requirements:

 

1. Create one column or measure to get the sum values of each product.

Column = CALCULATE ( SUM ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Product] ) )

Measure = CALCULATE ( SUM ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Product] ) )

 

2. You want to show the sum value of each product, expect for the selected product.

a. Create a table.

Product Filter = VALUES('Table'[Product])

b. Create a measure.

Condition = IF ( MAX ( 'Table'[Product] ) IN VALUES ( 'Product Filter'[Product] ), 1, 0 )

c. Put the condition measure on "Filters on this visual" of the visuals you want to filter.

 

BTW, .pbix file attached.

 

 

Best Regards,

Icey

 

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