Forum Discussion

Kpham's avatar
Kpham
Resolver I
6 years ago
Solved

matrix different description source per row

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 - ...
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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