Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Wikolin
Helper I
Helper I

Dynamic 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 2
Wikolin
Helper I
Helper I

Thank you @amitchandak 

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

amitchandak
Super User
Super User

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors