SUM Level range by List - slicer between option

[RajK2]

I've list of sales by vegetables wise as i need sum of value by range

Measure sales = sum(table[amount of sales])

if i apply filter between by sales (not rows - need SUM Level)

like it will show MIN Value = 25 MAX = 300 (As total) 

link this will give as row level not sum of sales:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-slicer-numeric-range

List	Amount by sales
papaya	30
orange	40
apple	50
mango	20
papaya	30
apple	40
orange	25
apple	35
mango	30

[v-ssriganesh]

Hi @RajK2,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-ssriganesh]

Hi @RajK2,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-ssriganesh]

Hi @RajK2,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @uzuntasgokberk for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solution? If so, please mark it as the solution. This will help other community members solve similar problems faster.

Thank you.

[uzuntasgokberk · Accepted solution]

Hello @RajK2  ,

Limitation of "https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-slicer-numeric-range"

Considerations and limitations

The following considerations and limitations apply to the numeric range slicer:

• The numeric range slicer filters every underlying row in the data, not any aggregated value. For example, let's say that you use a Sales Amount field. The slicer then filters each transaction based on the sales amount, not the sum of the sales amount for each data point of a visual.
• The numeric range slicer doesn't currently work with measures.
• You can type any number into a numeric slicer even if it is outside the range of values in the underlying column. This option lets you set up filters if you know the data may change in future.

The date range slicer allows for any date values even if they don't exist in the underlying date column.

If you'd like to see as sum someway. There is a solution that create a new table and you can write SUMMARIZE function such as:
SUMMARIZE(
 table,

table[list],

"Amount_sales", SUM(table[sales])

)

However, after creating the new table, it's important to establish the correct relationships. Once that's done, using the amount_sales field from the table will yield the expected results.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |