Forum Discussion
summarized dax
I just want to calculate how many unique customers have a value per date 1- less than 2$ 2- greater and equal to 2$ and less than 3$ 3- greater and equal to 3$ and less than 4$ 4- above 4$ ...
alialsayer , I thnk you need dynamic segmentation, refer my blog/Video
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
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 in a table to avoid performance issues.
