matrix different description source per row

[Kpham]

Matrix table:

use another description on first level description of the matrix table than the levels below the first level. 
should be:

Sales Order : 0000073456 - 00000088

level :   C541210 - PP_Quick Disc......

level     C541211 - PP_KOPP.....

Problem description: As it is I need to use three columns to show the relevant information. If  i can post the project definition on the place of the material descroption then everything would be more clear for the user

As is:

To be:

[Anonymous · Accepted solution]

Hi @Kpham ,

According to your screen shots, it seems you want to display the data from two fields into one field and the data from another field display in subtotal row. You can create a measure as below and put this new created measure to replace the field Material Description and Project Definition:

NmDes&pDef =
IF (
    ISINSCOPE ( 'Sales'[Sales Order] ) && NOT ( ISINSCOPE ( 'Sales'[Item] ) ),
    MAX ( 'Sales'[Project definition] ),
    MAX ( 'Sales'[Material Description] )
)

Best Regards

Rena

[amitchandak]

@Kpham ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format?

see if this can help

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Appreciate your Kudos.

[Kpham]

i have extended my problem description.. will this make it more clear