visual table
1 Topic
want to select values that are NOT in the slicer selection
I have a data table called GamesNotOnASite , example of data below; GameID SiteID CountryID 10 1 1 10 5 1 10 7 2 20 1 2 20 5 1 20 7 2 30 9 3 30 11 3 I want a viusal table or Matrix which has GameID's. I want two slicers, CountryID and SiteID. I want the CountryID to select the GameID's, I want the SiteID slicer to do the opposite, selecting a SiteID will show GameID's that are NOT in SiteID, but in the CountryID. Using the data example above I would get the following results; When countryID = 1 when SiteID = 1 Visual should show Game ID 20 When CountryID = 2 when siteID = 1 Visual would show GameiD = 10 Anyone know how to do this? I want to use measures as the actual table is 0.5Million rows Thanks!Solved1.4KViews0likes6Comments