Dynamic filter and calculations

[Wikolin]

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.

[Wikolin]

Thank you @amitchandak 

This did not solve my problem. Tried several ways, but it did not come out the way i needed.

[amitchandak]

@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/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k