topic Re: Create a measure which can be used for filtering a column based on another measure getting updated in DAX Commands and Tips

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

Basanth — Fri, 24 Nov 2023 10:13:55 GMT

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."

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

lukiz84 — Fri, 24 Nov 2023 11:58:07 GMT

Try

SELECTEDVALUE(MyTable[Product])

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

Basanth — Fri, 24 Nov 2023 14:38:04 GMT

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