Help with creating a second filtered slicer

[Navaneeth_V]

Hi, I have to create a second slicer, that contains the values that are not in the first slicer.
SO my first slicer take in values from Team[Team] and the relationships are as in the image

Now I have used a DAX formula, to generate another calcualted table, where if I selected a particular Team[TeamRatingID] and particular season from Season[SeasonKey], then it will generate all the other teams, not selected in the first slicer.
The example code is as shown:

So as you can see, i gave the values as numbers to the variable, and it is sorting correctly, as shown in Table visual.
The two card visuals are created using DAX formula of simply, SELECTEDVALUE(Team[TeamRatingID]) for SelectedTeam and SELECETDVALUE(Season[SeasonKey]) for SelectedSeason. Now this works in card visual. 

But the moment i use SELECTEDVALUE in the calculated table equation, it gives me blank

But the measures I use to filter are displaying properly in the card, but those values are simply not getting passed on for filtering. So it is comparing to a blank value.

Now inorder to check it , I just used MAX function instead of SELECTEDVALUE, So then the filtering condition is working, however this is not what I want.

You can see that MAX takes in the maximum values of 3523 and 11, and filters correctly, but it is the maximum of all values and not simply the SELECTEDVALUE.

How can solve this?

Thank you for your time

[lbendlin]

You cannot control a slicer from a measure directly. It will only work with disconnected tables, and only in one direction.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...