The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
28 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
33 | |
13 | |
12 | |
9 | |
7 |