Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
I have a line chart which show the sales of customers (over 1K). I have multiple slicers such as year, month, region etc, and one of slicer is customers which I can select a few customers (e.g. customer A, B and C). The line chart and slicers works very well. Now I need to show the sales of all customers at the same char, along with selected customers (e.g. customer A, B and C). How can I do that? Thanks
Solved! Go to Solution.
Hi,
See if my solution in the attached file helps.
Yes. To answer your question "where is the "total sales all customer" created?" that's up for you know, what goes there is the column or sum measure you are using to represent the numerical values. You won't need to include any selected customers in the formula, by using your filters and slicers, your measure will consider those as part of the row context.
Proud to be a Super User!
Thank you.
You can use a formula like this:
Total Sales All Customers = CALCULATE( SUM(SalesTable[SalesValuesColumn]), ALLEXCEPT('Customers Table', 'Customers Table'[Customer)))
Just keep in mind that if your chart has additional layers of segmentations, you'll need to add those fields in the ALLEXCEPT function (for example, the year column, the month, etc.)
Proud to be a Super User!
Thank you @ray_aramburo. Are you talking about create a new measure ? where is the "total sales all customer" created? those selected customers are dynamic, could be customer A, B,C or X, Y, Z depending on the user. So I am a little bit lost here how can I put the customers selected by slicers in the formula.
Yes. To answer your question "where is the "total sales all customer" created?" that's up for you know, what goes there is the column or sum measure you are using to represent the numerical values. You won't need to include any selected customers in the formula, by using your filters and slicers, your measure will consider those as part of the row context.
Proud to be a Super User!