Create a measure which can be used for filtering a column based on another measure getting updated

[Basanth]

Hi,

Wanted to create a measure which can be used in PowerBI Slicer when ActiveProduct (one measure from another table) is equal to Product column value.

ActiveProductMeasure = 
    IF (
        'MyTable'[Product] = [ActiveProduct],
        1,
        0
    )

But getting an error in measure DAX editor "A single value for column 'Product' in table 'MyTable' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

[Basanth]

I could connect slicer value to visual two ways,

1. Using a Measure created as above and used as filter 'is' '1'

ActiveProductMeasure = 
    IF (
        SELECTEDVALUE('MyTable'[Product]) = [ActiveProduct],
        1,
        0
    )

2. Created relationship between Products[Name] and MyTable[Product] - after this I could see any slicer added for filtering filters both the visuals. Inn case you have slicer in a different page you can also use 'Slicer Sync' https://learn.microsoft.com/en-us/power-bi/developer/visuals/enable-sync-slicers

[lukiz84 · Accepted solution]

Try 

SELECTEDVALUE(MyTable[Product])