How to stop summarizing specific fields in Matrix visual

Hi RD2019 

Create measures

Measure_column3 =
IF (
    ISINSCOPE ( 'Table'[column2] ),
    MAX ( 'Table'[column3] ),
    IF ( ISINSCOPE ( 'Table'[column1] ), BLANK (), BLANK () )
)

Measure_column4 =
IF (
    ISINSCOPE ( 'Table'[column2] ),
    SUM ( 'Table'[column4] ),
    IF ( ISINSCOPE ( 'Table'[column1] ), BLANK (), BLANK () )
)

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Maggie,

Thanks for this...I think this would work as well. However I have applied a work-around using HASONEVALUE only. As in my case, every product has the same label code and rate - I have just use an IF condition stating that if there is one value for any label or rate (although there can be multiple occurances) - just take the AVERAGE value, otherwise BLANK (ensuring the subtotal will be blank). Seems that it's working fine now.