Matrix Table with same values

[Carlend]

Good morning, I need your help. I have generated a matrix table shown in the photo. As you can see from the dataset I have two values ​​(E and I) for the same code associated with a specific week number (26). How can I display them both within the matrix table? I attach a screen to facilitate understanding of the scenario

Screen2. Dataset

Screen1. Matrix Table

[v-lionel-msft]

Hi @Carlend ,

Yes, this problem does exist because the ‘Value' label in the matrix need aggregate fields.

So you may need to consider using table visual.

Or use @harshnathani 's formula to combine the text values.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[harshnathani]

Hi @Carlend ,

You can try this measure

Measure =
CONCATENATEX (
    FILTER (
        'Table',
        'Table'[N_Week]
            = MAX ( 'Table'[N_Week] )
    ),
    'Table'[Fase_EXMNT],
    ","
)

Regards,

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

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