Multiples selected values to display as one specific text
Hi friends, I'm trying to get a text display in a card box, based on the filters that I'm choosing on the screen. But my problem is: when I choose a specific filter under a macro filter, my DAX formula keeps me returning the macro and not the specific filter. For instance: I would like to display "AMERICA" instead of "INTERNATIONAL", but the value "AMERICA" belongs to "INTERNATIONAL". My measure is currently: DisplayText = "LOGISTICS OVERVIEW FEV - " & IF( SELECTEDVALUE( COLUMN 1 ) = "INTERNATIONAL" ; "INTERNATIONAL" ; IF( SELECTEDVALUE( COLUMN 1 ) = "HALAL"; "HALAL" ; SELECTEDVALUE(COLUMN 2) ) ) The table structure is basically: COLUMN 1 (MACRO) COLUMN 2 (MARKET) INTERNATIONAL AFRICA INTERNATIONAL EUROPE INTERNATIONAL EURASIA INTERNATIONAL ASIA INTERNATIONAL AMERICA HALAL MIDDLE EAST Does anyone know how to fix this? Thanks!
