Forum Discussion
Helper IIDynamics Deal Band
Hi,
I have a set of data similar to below and I want to create a Dynamic deal band DAX based on the filter select.
For example,
If I select region, total amount for region B is $200 and deal Band will be $200-$250.
If I select product C, total amount for product C is $150k and deal band will be $100-$200
What is the best way to present this? Is it possible to write a DAX? Or I should create separate tables in the query for the calculation?
| Region | Customer Name | Product | Sales Amount |
| B | gfhgd | A | 100 |
| B | fhjh | C | 100 |
| etrwyre | werwet | C | 50 |
Thanks for your advice.
irenelitw629 , I think you need Dynamic Segmentation
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
3 Replies
- amitchandak
Super User
irenelitw629 , I think you need Dynamic Segmentation
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k 
irenelitw629Thanks! This is brilliant. However this only allows me to present data in table with customer name in first column.
Once I removed customer name and converted to stacked column chart the Dynamic calculation is not working anymore.
Is there any way to create stacked column chart to show Dynamic Segmentation? For example, in your sample file I would like to present % of customer by margin type.
- amitchandak
irenelitw629 , if your measure has a customer name or table in the formula, you can remove a customer from visual
Sumx(customer, calculate(Sumx(bucketTable, <Calculation>) ) )
or
Sumx(values(customer[Name]) , calculate(Sumx(bucketTable, <Calculation>) ) )