topic Re: Dynamic filter and calculations in DAX Commands and Tips

Dynamic filter and calculations

Wikolin — Wed, 01 Sep 2021 08:17:18 GMT

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.

Re: Dynamic filter and calculations

amitchandak — Wed, 01 Sep 2021 09:39:27 GMT

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

Re: Dynamic filter and calculations

Wikolin — Wed, 01 Sep 2021 13:24:49 GMT

Thank you amitchandak

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