Forum Discussion

sananthv's avatar
sananthv
Icon for Helper II rankHelper II
7 years ago
Solved

CONCATENATEX appearing in table total

 

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. 

 

 

Need Help
  • OwenAuger's avatar
    OwenAuger
    7 years ago

    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

1 Reply

  • OwenAuger's avatar
    OwenAuger
    Icon for Super User rankSuper User
    7 years ago

    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