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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.
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.

Super User
Super User

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.