Dynamic Segmentation/ Bucketing/ Binning

Dynamic Segmentation/ Bucketing/ Binning Created an independent bucket Table. Create measures that take advantage of those buckets Actual Measure Margin % = DIVIDE([Margin],[Sales])...

Retail Bucket Data.pbix1.1 MB

Mathematical

Totals

alialsayer

Helper I

3 years ago

This is fantastic; thank you for your prompt response; however, I have a slightly different situation. First, I have to group values by date for each customer, and then I should use the bucket. I am trying to find a way to do this in the DAX function instead of grouping values for each customer & date in a table to avoid performance issues.