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.
Helper IVyes, I only have one table of data. Job Family and Nominations are columns within the same data table.
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.
- mmills2018
So, 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?