Hello all,
I have seen many posts that seem to be my use case, but the solutions are not working for me.
Using solution from this post: https://community.powerbi.com/t5/Desktop/Disconnected-Slicer-to-slice-a-table/m-p/2526123
The visual is a card, representing a distinct count of a different Facts2 [field2] that should change based on slicer selection filtering Facts2[field1] .
I have two facts tables, with many same fields and 1 Bridge table with a common field that I want to use as a slicer. The only relationship between the facts tables is a 1 to Many, single direction. And the bridge table to each of the facts table, 1 to many 1 direction. The slicer is only slicing 1 of the tables not both.
I have seen where the solution is to create a measure that is used as a visual filter where the filter is set to 1. 1 represents the value on facts table row when the field value matches selected value.
Measure 1 to capture selected value from Facts2 :
SlcCareerTrack = SELECTEDVALUE('Slicer'[Value])
Measure 2 in table to return 1 when selected Value from slicer matches field value in table:
SelCareerTrack =
var _sel = [SlcCareerTrack]
var _CarTrk = MAX(Facts2[Career Track])
Return
If(CONTAINSSTRING(_CarTrk,_sel),1,0)
Issue 1 - "var _sel = [SlcCareerTrack]" - This is supposed to reference the (facts2)[field] but it will only accept measures or functions. It will not accept (facts table)[field]?? - RESOLVED - Is looking for the value in Measure 1 NOT Facts table
Issue 2 - The visual is a card, representing a distinct count of field that should change based on slicer selection. When applying the visual filter Measure2 'is 1' - The filter will not allow me to modify the 'is'. I cannot change the operator nor select the filter options at all. Its like its frozen. RESOLVED!!! - I changed the card to a table and added the Facts2[Field] which allowed me to configure the filter and then change back to a card!!
Issue 3 - When putting this in a table to see the actual data - The Slicer selected value assigns to all rows, which gives them an automatic 1?? RESOLVED. Value 1 assigns appropriately based on slicer selection with resolution on issue 1
Please help??
