Do not show totals in all array columns

[Syndicate_Admin]

Hello

Having the following matrix, how can I show only the total of the last column and hide the total of the others?

Thank you.

[Tahreem24 · Accepted solution]

@Syndicate_Admin You can use the white font color for those columns which you don't want to display total. Refer the below screen shot.

[Bibiano_Geraldo]

Hi @Syndicate_Admin ,

To achieve desired result use ISINSCOPE function, modify your measures to look like bellow:

Primera fecha: Fecha_Pedido = 
IF(
    ISINSCOPE(YourTable[Document No_]),
    
    //PASTE HERE THE CALCULATIONS OF YOUR MEASURE Primera fecha: Fecha_Pedido
    
    ,BLANK()
)

Primera fecha: Shipment Date = 
IF(
    ISINSCOPE(YourTable[Document No_]),
    
    //PASTE HERE THE CALCULATIONS OF YOUR MEASURE Primera fecha: Shipment Date
    
    ,BLANK()
)

Ultima fecha: Sell-to Customer No_ = 
IF(
    ISINSCOPE(YourTable[Document No_]),
    
    //PASTE HERE THE CALCULATIONS OF YOUR MEASURE Ultima fecha: Sell-to Customer No_
    
    ,BLANK()
)