Forum Discussion
Wikolin
Helper I
Helper IDynamic filter and calculations
Hi all.
I'm a bit stuck on this one.
I have a list of customers and their sales. If sales is above 1000 in total the last 12 months i want to tag them with "High", the rest of customers "Low". This i figured out:
Category = IF(SUM(sales[amount])>1000,"High","Low")
In a report i want to filter on a customer. This customer is "High" or "Low".
So i want the average sales in the "High"-category. And if i filter on another customer who turned out to be "Low" i want the average sales in "low"-category.
2 Replies
- amitchandak
Super User
Wikolin , Try Binning or bucketing
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
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 
WikolinThank you amitchandak
This did not solve my problem. Tried several ways, but it did not come out the way i needed.
