Calculation based on filter selection

Hi dariog ,

Create a separate table by entering data

This is the measure I created

Result = 
IF (
    SELECTEDVALUE ( 'Table (2)'[Category] ) = "Country",
    CALCULATE ( SUM ( 'Table'[Sales] ), ALL ( 'Table' ) ),
    CALCULATE (
        SUM ( 'Table'[Sales] ),
        FILTER ( 'Table', [Location] IN ALLSELECTED ( 'Table (2)'[Category] ) )
    )
)

Country is selected

East and North are selected

You check details from the attachment.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.