Forum Discussion
Helper IVSlicer to Column relationship
Add a calculated column to your table like this.
Nomination matches Job Family = CONTAINSSTRING('Table'[Nomination],'Table'[Job Family])It will return true when the nomination contains the job family:
Then you use that as filter on your report page.
Super UserOK, then your slicer is already related to the field. When you pick a job family in the slicer what that does is apply a filter to the table where only the selected job families are returned. It will only show nominations where the job family is the ones you selected.
Helper IVSo, within my data, you can have a job family of IT but a nomination for HR. So, I only want to pull those who have a job family of IT and a nomination of IT
- jdbuchanan71
Add a calculated column to your table like this.
Nomination matches Job Family = CONTAINSSTRING('Table'[Nomination],'Table'[Job Family])It will return true when the nomination contains the job family:
Then you use that as filter on your report page.
- mmills2018
Thanks! this makes sense, for 'containsstring', it will only let me choose a measure and not a column? does it have to be a measure?
- jdbuchanan71
That's not true of CONTAINSSTRING. In my example I am adding a calculated column to the table and only looking at the columns in the table.