CONCATENATEX appearing in table total

[sananthv]

I am using CONCATENATEX to combine rows (the "Name" column in the example given bellow). Wondering how to remove the values appearing in the totals row. 

[OwenAuger · Accepted solution]

Hi there,

You could do add some sort of check to your measure to ensure you return a result only for individual Identifiers.

The first measure works by detecting when a single Identifier value is visible.

The second measure works in a table visual where you have Identifier on the rows, and returns a nonblank value only at the "level" of a single Identifier.

Name without total =
IF (
    HASONEVALUE ( YourTable[Identifier] ),
    CONCATENATEX(...)
)

Name without total =
IF (
    ISINSCOPE ( YourTable[Identifier] ),
    CONCATENATEX(...)
)

Regards,

Owen