Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Dear community, for a Dax formula I need your help.
As a data source, i have an Excel file with sales from 2019.
"Column A" shows all invoice numbers, "Column B" shows the invoice amount, "Column C" shows the customer-ID.
Some customers have purchased multiple products through an invoice-number. As a result, invoice numbers occur several times with different amounts. Now I would like to add the sum of the unique invoices like: "if sum unique invoice <10 then "<10"; if >=10 & <20;" 10-19.99" and so on.
I would be happy if you could help me, thank you!
Daniel
Solved! Go to Solution.
@Anonymous , Bucketing/segmentation. You have created an independent table with buckets.
Min value, Max Value, Bucket name
measure
Amount = sum(Table[Column C])
measure with bucket table
sumx(filter(values(Table[Column A]) , [Amount] >= Min(Bucket[Min Value]) && [Amount] <= max(Bucket[Max Value]) ), [Amount])
So this for all the measures you want with bucket table.
refer my video or blog on that
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
@Anonymous , Bucketing/segmentation. You have created an independent table with buckets.
Min value, Max Value, Bucket name
measure
Amount = sum(Table[Column C])
measure with bucket table
sumx(filter(values(Table[Column A]) , [Amount] >= Min(Bucket[Min Value]) && [Amount] <= max(Bucket[Max Value]) ), [Amount])
So this for all the measures you want with bucket table.
refer my video or blog on that
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
23 | |
10 | |
10 | |
9 | |
7 |