Forum Discussion
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?
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:
How to Get Your Question Answered Quickly
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
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:
How to Get Your Question Answered Quickly
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.