SUM Level range by List - slicer between option

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 |