CONCATENATEX with count

[Sudbrl]

Dear ALL,

For a report, I want to achieve concat with the count. Please provide a solution on DAX measure for power pivot.

Result/Output

Name	RegionCount
Anil	A1(2),A2(2)
Sunil	A1(2),A2(2)

@Greg_Deckler 

Table

Name	Region
Anil	A1
Anil	A1
Anil	A2
Anil	A2
Sunil	A1
Sunil	A1
Sunil	A2
Sunil	A2

[smpa01 · Accepted solution]

@Sudbrl  you can do this

Measure 2 = 
CONCATENATEX (
    ADDCOLUMNS (
        SUMMARIZE ( 'fact', 'fact'[Name], 'fact'[Region] ),
        "result",
            [Region] & "," & "("
                & CALCULATE (
                    DISTINCTCOUNT ( 'fact'[Region] ),
                    ALLEXCEPT ( 'fact', 'fact'[Name] )
                ) & ")"
    ),
    [result],
    ",",
    [Name]
)