Selected Value Blank

Hi Anonymous ,

here is one way of achieving what you want to do:

Measure =
VAR _names =
    VALUES ( Master[name] )
VAR _c1 =
    CALCULATE ( SUM ( data[sales] ); FILTER ( data; data[Column1] IN _names ) )
VAR _c2 =
    CALCULATE ( SUM ( data[sales] ); FILTER ( data; data[Column2] IN _names ) )
VAR _c3 =
    CALCULATE ( SUM ( data[sales] ); FILTER ( data; data[Column3] IN _names ) )
VAR _c4 =
    CALCULATE ( SUM ( data[sales] ); FILTER ( data; data[Column4] IN _names ) )
RETURN
    _c1 + _c2 + _c3 + _c4

although with only 4 columns, but you get the picture. For this to work, you need to remove all the connections between Master and Data.

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.