Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Create to segmentation with measue (numeric)

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.

 

 

 

 
Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    Anonymous , 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