SUM values slicer in Between option

Anonymous For this, create a measure like Total Amount = SUM('Table'[Amount]) and use it in the slicer. The slicer will now filter based on the total sum, showing both Apple and Banana if their combined value meets the condition.

Hi Anonymous ,

In Power BI, a standard "Between" slicer works on individual row values, not on aggregated values like the sum of amounts per name. In your example, the slicer on amount would only include rows where the individual amount is greater than 40, which is why only Banana (44) shows up, and Apple (10 and 33) gets excluded—even though its total is 43. To fix this and apply the slicer based on the sum of amounts per name, you’ll need to create a summary table that groups data by name and calculates the total amount. Use this table as the basis for your slicer, and then filter the original table accordingly.

First, create a summarized table using DAX like this:

NameSummary =
SUMMARIZE(
    'YourTable',
    'YourTable'[name],
    "TotalAmount", SUM('YourTable'[amount])
)

This gives you a new table with unique names and their total amounts. You can then create a slicer on the TotalAmount column from the NameSummary table. Since slicers and visual filters don’t automatically filter the original table by aggregation, you need a measure to bridge the logic between the two.

Define a DAX measure like this:

ShowNameFlag =
VAR SelectedMin = MIN('NameSummary'[TotalAmount])
VAR SelectedMax = MAX('NameSummary'[TotalAmount])
VAR ThisName = SELECTEDVALUE('YourTable'[name])
VAR ThisTotal =
    CALCULATE(
        SUM('YourTable'[amount]),
        ALLEXCEPT('YourTable', 'YourTable'[name])
    )
RETURN
IF(
    ThisTotal >= SelectedMin &&
    ThisTotal <= SelectedMax,
    1,
    0
)

Apply this measure as a visual-level filter in your table where ShowNameFlag = 1. This way, the table visual will only show names whose total amount falls within the selected range in the slicer—even though the original table still contains individual line items. This workaround bypasses the slicer's limitation and gives you the correct aggregated filtering behavior.

Best regards,

Create a calculated table or measure to filter based on SUM per name, not row-level values.

Create a measure to calculate the sum of amount by name:

TotalAmountByName = CALCULATE(SUM('Table'[amount]), ALLEXCEPT('Table', 'Table'[name]))

Create a new disconnected table for your slicer:

SlicerTable = GENERATESERIES(0, 100, 1)
This gives values 0 to 100 for use in the slicer.

Create a measure to capture selected value from slicer:

SelectedMinAmount = SELECTEDVALUE(SlicerTable[Value], 0)

Create a measure for filtering visual rows:

ShowName = VAR TotalAmt = CALCULATE(SUM('Table'[amount]), ALLEXCEPT('Table', 'Table'[name])) RETURN IF(TotalAmt >= [SelectedMinAmount], 1, 0)

Apply this as a visual-level filter on your table:

Go to your visual.

Add the ShowName measure to the Filters pane.

Set it to show only when value = 1.

Hi Anonymous ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

Hi @RajK2 ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

Hi Anonymous ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

Hi Anonymous ,
I have tried to reproduced the scenario using the measure provided by Vijay_Chethan  and was able to get the result.
Please find the file attcahed.
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!

Hi Anonymous ,
You can try to use this-
Slicer Measure =
CALCULATE(
SUM('Table'[Amount]),
ALLEXCEPT('Table', 'Table'[Name], 'Table'[Year], 'Table'[Quarter])
)
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!