Measure in DAX to represent sales in the customer's state

[FelipMark]

Hi everyone, I have a problem.

I have the following database:

I want to create a measure that returns the % of sales of each customer within their state but I don't know how. Can anyone help me??

[FreemanZ]

hi @FelipMark 

try to add a calculated column like:

Column = 
DIVIDE(
    [SALE],    
    SUMX(
        FILTER(
            data,
            data[State]=EARLIER(data[State])
        ),
        data[Sale]
    )
)

it worked like:

Is that so?

[FelipMark]

not working, the error says the following:
EARLIER/EARLIEST references a previous row context that does not exist.

[FreemanZ · Accepted solution]

hi @FelipMark 

just noticed you expected a measure, try like:

measure = 
DIVIDE(
    SUM(data[SALE]),    
    SUMX(
        FILTER(
            ALL(data),
            data[State]=MAX(data[State])
        ),
        data[Sale]
    )
)

it worked like:

[FelipMark]

It worked! Thanks