cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sananthv
Advisor

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. 

 

concatenatex.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: CONCATENATEX appearing in table total

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




1 REPLY 1
Super User
Super User

Re: CONCATENATEX appearing in table total

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!