Have a trouble: need to subtotal all lines, except .INDICADORES. Is that possible ?

[Rabelo]

Is it possible to define wich kind of data to SUBTOTAL in a matrix ?

In this case, I'd like that all .INDICADORES data sholud't SUBTOTAL.

Thanks so much !! 😅

[Anonymous]

Hi @Rabelo ,

Pleae try this measure:

subtotal =
IF (
    ISINSCOPE ( 'table'[subrow] ),
    SUM ( 'table'[value] ),
    CALCULATE (
        SUM ( 'table'[value] ),
        FILTER ( ALLSELECTED ( 'table' ), 'table'[subrow] <> ".INDICADORES" )
    )
)

Best Regards,

Jay 

[Rabelo]

Thks so much!!! 

I've decided to avoid this aproach ... better separate in 2 differente tables and 2 matrixes.

Best Regards!!!

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[Rabelo]

Thks so much!!! 

I've decided to avoid this aproach ... better separate in 2 differente tables and 2 matrixes.

Best Regards!!!

[tamerj1]

Hi @Rabelo 

yes possible. Please clarify exactly the filter contrxt of this matrix. Which columns and which tables. Sample data would be greatly hepful to create a sample file for you. Thank you

[Rabelo]

Thks so much!!! 

I've decided to avoid this aproach ... better separate in 2 differente tables and 2 matrixes.

Best Regards!!!