Create to segmentation with measue (numeric)

[katherinedelva]

I want to create a segmenter with a measure (price) that I have created which has millions of records. How can I make it so that I can bring only the values ​​I want to the SalePrice filter?
It won't let me include it in the segmenter.

[amitchandak]

@katherinedelva , You need to use numeric parameter or create dynamic segemetantation

With numeric of what is parameter or using generateseries create a table

Bucket = generateseries(0, 2000, .01)

But this going to too many values

Then you can have measure like

Measure =

new measure =
var _max = maxx(allselected(Bucket ),Bucket [value])
var _min = minx(allselected(Bucket ),Bucket [Date])
return
calculate( Sumx(filter(Values('Table' [Nonbre]), [Price] >=_min && [Price]<=_max))

Assuming the price is a measure

https://docs.microsoft.com/en-us/power-bi/desktop-what-if