Sales range by customer

Hi Lazuriii,

I'd like to suggest you create a disconnected table as source of slicer, then you can write a measure formula to check the aggregated value and return flag.

flag =
VAR selection =
    ALLSELECTED ( NewTable[Value] )
VAR currSales =
    CALCULATE (
        SUM ( Table1[Sales] ),
        ALLSELECTED ( Table1 ),
        VALUES ( Table1[Customer] )
    )
RETURN
    IF (
        currSales >= MINX ( selection, [Value] )
            && currSales <= MAXX ( selection, [Value] ),
        "Y",
        "N"
    )

After these steps, you can use this measure formula on the table visual 'visual level filter' to filter records that match with flag.

Regards,

Xiaoxin Sheng

Hi,

I have solved a similar problem in the attached file.

Hope this helps.