My expression checks if column “Angelfish Blanks” contains the value “1”:
SELECT(Student Dinners[Class], CONTAINS([Angelfish Blanks], “1”,),([Class] = [_THISROW].[Class]))
How would I add two further Columns to the CONTAINS part of the expression? I need to add “Dolphin Blanks” and “Pufferfish Blanks” columns.