Skip to main content
cancel
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

New Member

## How do I use a slicer for columns with summarized data?

Hello!

I have a matrix with three columns:

• Column 1 = two values of identifying data (for example, Name and Work Location).
• Column 2 = sum of sales generated (summarized by name, then broken down by work location)
• Column 3 = sum of clients (summarized by name, then broken down by work location)

I want to create a slicer that looks at the sum of column 2 (highlighted yellow in the picture) for those who have a specific \$ amount or higher - i.e. over 150,000.  Previous slicers and measures I have created will only pull the values by work location over the \$ amount, but I need it to reference the SUM by name and keep the work location information.  Can someone help point me in the right direction?

1 ACCEPTED SOLUTION
Community Support

Hi, @MZimmer1

Based on your information, I create a sample table:

Use DAX to create a measure that calculates the total sales for each name across all work locations:

``Total Sales per Name = CALCULATE(SUM('Table'[Sales]), ALLEXCEPT('Table', 'Table'[Name]))``

Here is my preview:

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 REPLY 1
Community Support

Hi, @MZimmer1

Based on your information, I create a sample table:

Use DAX to create a measure that calculates the total sales for each name across all work locations:

``Total Sales per Name = CALCULATE(SUM('Table'[Sales]), ALLEXCEPT('Table', 'Table'[Name]))``

Here is my preview:

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

## Helpful resources

Announcements

#### 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 Monthly Update - August 2024

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

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors