Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
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."
Solved! Go to Solution.
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
Try
SELECTEDVALUE(MyTable[Product])
User | Count |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
13 | |
11 | |
7 |