FILTER CONTEXT IN TABLE VISUAL

[FrankWoodyblue]

Hello, I have a doubt regarding the use of the visual table, according to the image below I have a table that has two rows A with the same values in the column but the ID are different. If I simply drag the values to the table, power Bi considers only one line for the A values as shown below.

However, I would like to display the two values referring to line A as shown in the image below

However I would not want the ID column to be in the table visual.
I have already explored the option not to summarize but it still does not display another value from line A.

@AlB  @amitchandak  @FreemanZ 

[tamerj1 · Accepted solution]

Hi @FrankWoodyblue 
You can create a new column as folows and then use it in the table

DESCRIPTION2 = 'Table'[DESCRIPTION] & REPT ( UNICHAR ( 13 ), 'Table'[ID] ) 

[FrankWoodyblue]

Thanks for your anwser.
1º but the ID are text like this "TKlyl6DaVk6_R4dEG3LGgGUAKQif" so  the dax formular can't convert the text to integer.
2º But Ive go to power query and creat a INDICE  collumn so used it inside the dax formula that you posted. So it's solved.
3º Two doubt, this result can compromet the original values of the description ?
can I transforme this calculate colllumn in measure ?

[tamerj1]

@FrankWoodyblue 

2. Nothing that cannot be handled. 
3. the column is required to slice by. You cannot slice by a measure 

[FrankWoodyblue]

Thank you for your replay but I cant do that couse in this case I'm use number's as ID to do a example but at the original context the ID are largest text so when I reducing the width of that column the height is distorted.
I thought a have to do a measure that return the description but using the ID as a filter to show all lines without resume. But I dont know how to write it. Could you help me ?

[AlB]

Hi @FrankWoodyblue 

Try keeping ID in the table but reducing the width of that column to (almost) zero so that the column is actually not shown

Without that column the As will be shown only once since all the values in the row are the same

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.