Forum Discussion
Solved
Display unfiltered values from a column when a filter is applied on another column
Hey there. I'm in need of a little help, much appreciated. I have attached a pbix file with a sample dataset of my problem. Basically I have two categorical columns in my dataset (Name and City...
v-yanjiang-msft Thanks a bunch, yes your solution totally works for concatenating the unfiltered values.
I was looking to display them in a table, so I also figured out a solution for that as below:
Created a table with unique values for each 'City' and created a normal relationship (1 to *) with the fact table (my_data), then added 'City' to a table visual.
AllNames = VALUES(my_data[City])
Created 3 measures in 'my_data':
filteredCityCount = CALCULATE(COUNTROWS(DISTINCT(my_data[City])))
totalCities = CALCULATE(DISTINCTCOUNT(my_data[City]),ALL(my_data))
finalFilter =IF ( [totalCities] - [filteredCityCount] = [totalCities], 1, 0)
Added finalFilter = 1 as a filter to the table visual. I've updated the sample pbix file in the opening post with both solutions.