What if Parameter multiple parameters on same column

Hi acbg ,

If some customer has same rebate value, we can create some parameter with a customer select slicer to reduce the number of parameter

1. create some parameter for each rebate value ( for example , we create five kind of rebate table)

2. create some customer calculated table, they have same formula but have different name

Customer of Rebate 1 = DISTINCT('Table'[Customer Name])

3. create a measure to calculate the total sales

Total Sales After Rebate = 
IF (
    ISFILTERED ( 'Customer of Rebate 1'[Customer Name] ),
    CALCULATE (
        SUM ( 'Table'[Sales] ) * ( 1 - [Rebate 1 Value] ),
        'Table'[Customer Name]
            IN FILTERS ( 'Customer of Rebate 1'[Customer Name] )
    ),
    BLANK ()
)
    + IF (
        ISFILTERED ( 'Customer of Rebate 2'[Customer Name] ),
        CALCULATE (
            SUM ( 'Table'[Sales] ) * ( 1 - [Rebate 2 Value] ),
            'Table'[Customer Name]
                IN FILTERS ( 'Customer of Rebate 2'[Customer Name] )
        ),
        BLANK ()
    )
    + IF (
        ISFILTERED ( 'Customer of Rebate 3'[Customer Name] ),
        CALCULATE (
            SUM ( 'Table'[Sales] ) * ( 1 - [Rebate 3 Value] ),
            'Table'[Customer Name]
                IN FILTERS ( 'Customer of Rebate 3'[Customer Name] )
        ),
        BLANK ()
    )
    + IF (
        ISFILTERED ( 'Customer of Rebate 4'[Customer Name] ),
        CALCULATE (
            SUM ( 'Table'[Sales] ) * ( 1 - [Rebate 4 Value] ),
            'Table'[Customer Name]
                IN FILTERS ( 'Customer of Rebate 4'[Customer Name] )
        ),
        BLANK ()
    )
    + IF (
        ISFILTERED ( 'Customer of Rebate 5'[Customer Name] ),
        CALCULATE (
            SUM ( 'Table'[Sales] ) * ( 1 - [Rebate 5 Value] ),
            'Table'[Customer Name]
                IN FILTERS ( 'Customer of Rebate 5'[Customer Name] )
        ),
        BLANK ()
    )
    + CALCULATE (
        SUM ( 'Table'[Sales] ),
        IF (
            ISFILTERED ( 'Customer of Rebate 1'[Customer Name] ),
            NOT 'Table'[Customer Name]
                IN FILTERS ( 'Customer of Rebate 1'[Customer Name] ),
            TRUE ()
        ) && IF (
            ISFILTERED ( 'Customer of Rebate 2'[Customer Name] ),
            NOT 'Table'[Customer Name]
                IN FILTERS ( 'Customer of Rebate 2'[Customer Name] ),
            TRUE ()
        )&& IF (
            ISFILTERED ( 'Customer of Rebate 3'[Customer Name] ),
            NOT 'Table'[Customer Name]
                IN FILTERS ( 'Customer of Rebate 3'[Customer Name] ),
            TRUE ()
        )&& IF (
            ISFILTERED ( 'Customer of Rebate 4'[Customer Name] ),
            NOT 'Table'[Customer Name]
                IN FILTERS ( 'Customer of Rebate 4'[Customer Name] ),
            TRUE ()
        )
        && IF (
            ISFILTERED ( 'Customer of Rebate 5'[Customer Name] ),
            NOT 'Table'[Customer Name]
                IN FILTERS ( 'Customer of Rebate 5'[Customer Name] ),
            TRUE ()
        )
    )

Hi acbg ,

If some customer has same rebate value, we can create some parameter with a customer select slicer to reduce the number of parameter

1. create some parameter for each rebate value ( for example , we create five kind of rebate table)

Best regards,