Show the data based on slicer selection in table visual

[Anonymous]

Hi Team,

I have 3 tables(Comments, Date & Country). 

Country table has only 5 regions & Comments table has one additional entry as Global. Below is how the tables are conencted.

Requirement: If nothing is selected in slicer it should show Global comments in table visual else Regional comments.Also it should change based on Date slicer.
I have used below DAX and could reach somewhat near but not getting output as expected.

Problem: In my Comments table there are multiple entries for "APAC". When I select APAC i get error in visual. Also it shows BLANK when I select Date slicer even though there is only 1 entry per region.

Need help on: If the Comments table has multiple region with same name it should show all comments or should changed based on dates. 

Snapshot of Country & Comments table as below:

Help is really appreciated. Thanks in advance.

Comments Table

Country Table

Regards,

PS

[MFelix · Accepted solution]

Hi @Anonymous ,

You are getting the errors since you are returning VALUES in a measures and this returns several values when the return must be a single value try the following measure:

Comments =
IF (
    ISFILTERED ( Country[Region_Mapping] ),
    CONCATENATEX (
        VALUES ( Comments[Radar Chart Comments] ),
        Comments[Radar Chart Comments],
        ","
    ),
    CALCULATE (
        MAX ( Comments[Radar Chart Comments] ),
        FILTER ( Comments, Comments[Region] = "Global" )
    )
)

This will return a concatenated text:

[Anonymous]

@MFelix Thank you so much. Its working on a sample data. I will try on actual data too.