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

Regular Visitor

CALCULATE Function Filter Help



I am new to Power BI and have done some basic training through Microsoft but need some help-


I want to build a line graph that has 2 lines:

1) Total performance over time for a catagory of products, all customers

2) Total performance over time for a catagory of products, a specific customer- with this being changed by a slicer.


The aim is that my sales team can see how different retailers are doing with a product compared to the market as a whole.


I have determined that I need to somehow have the "customer" slicer to not impact line 1 referenced above.

I beleive I can do this using a CALCULATE function but have spent the best part of a day looking online and trying myself- any help would be really appreciated!


Please let me know if there is anything else/screenshots that I can provide to help-




Resolver I
Resolver I

Give us some sample data / what you want to filter out.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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