Measure Stop Filtering For Sub columns

Hi, selpaqm 

Try to create a measure like this:

__Measure =
VAR _customer =
    CALCULATE (
        SUM ( 'Table'[Sales] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Customer] = MAX ( 'Table'[Customer] )
        )
    )
VAR _brand =
    CALCULATE (
        SUM ( 'Table'[Sales] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Brand] = MAX ( 'Table'[Brand] ) )
    )
RETURN
    DIVIDE ( _customer, _brand )

result:

It is recommended to use percentage formatting, otherwise you will only see 0 or 1

Please refer to the attachment below for details

Hope this helps.

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

selpaqm 

measure1:

__divide = 
var _customer=CALCULATE(SUM('Table'[Sales]),FILTER(ALLSELECTED('Table'),'Table'[Customer]=MAX('Table'[Customer])))
var _brand=CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'),'Table'[Brand]=MAX('Table'[Brand])))
var _divide=DIVIDE(_customer,_brand)
return _divide

measure2:

_result = 
VAR _sum =
    SUMMARIZE ( 'Table', [Customer], [Brand], [Sales], "1", [__divide] )
RETURN
    SUMX ( _sum, [1] )

result:

 Best Regards,
Community Support Team _ Zeon Zheng