Show Non-Matching Values

[Anonymous]

Hi, I have a table with customers and their favorite food formatted as text.

I would like to select Carlos and show, in a table visual (see pic above), his non-favorite foods. How can I go about creating DAX to show this?

Thank for any help.

[amitchandak · Accepted solution]

@Anonymous , the second table should have below measure with favorite food column.

measure =
var _tab = except(all(Table[favorite food]), allselected(Table[favorite food]))
return
calculate(count(Table[favorite food]), filter(all(Table), Table[favorite food] in _tab))

Do not go by value of meausre

[CNENFRNL · Accepted solution]

[amitchandak · Accepted solution]

@Anonymous , the second table should have below measure with favorite food column.

measure =
var _tab = except(all(Table[favorite food]), allselected(Table[favorite food]))
return
calculate(count(Table[favorite food]), filter(all(Table), Table[favorite food] in _tab))

Do not go by value of meausre