Power BI Matrix visual with SELECTEDVALUE text values

[Jas359]

Hi,

I have a matrix visual with texts in value field (as I need them to be on the same line).

CutomerName= ('Customer'[Customer Name])

I use SELECTEDVALUE measure, however I need to display SelectedValue "textmeasure" for "order number" level but not to display under "order subline" subcategory level.

For example I need to have Sales amount for each "order subline" level, but the name of customer only on the level of order number and not to repeat it under each order subline. 

Thank you in advance for your help.

[Jas359]

Hi Felix, thank you for your reply. This solution gives the same result: it repeats the customer name both on the level order number and on subline levels.

[MFelix]

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[MFelix]

Hi @Jas359 ,

Try the following measure:

Customer = IF(ISINSCOPE(Table[Order]), ('Customer'[Customer Name]))