Forum Discussion

tfiegel037's avatar
tfiegel037
Regular Visitor
2 years ago
Solved

Create a slicer that also combines multiple selections

I have a data set that contains five regions, but I want to create a slicer that lists seven items: the five individual regions, a combined region, and then all regions. I don't just want to use grou...
Need Help
  • DataInsights's avatar
    DataInsights
    2 years ago

    tfiegel037,

     

    This solution uses the two tables below. There are various ways to create them (manually, DAX, Power Query).

     

     

     

     

    Measure:

     

    Total Sales = 
CALCULATE (
    SUM ( FactTable[Sales] ),
    CROSSFILTER ( RegionGroups[Region], FactTable[Region], BOTH )
)

     

     

     

     

DataInsights's avatar
DataInsights
Super User
2 years ago

tfiegel037,

 

This solution uses the two tables below. There are various ways to create them (manually, DAX, Power Query).

 

 

 

 

Measure:

 

Total Sales = 
CALCULATE (
    SUM ( FactTable[Sales] ),
    CROSSFILTER ( RegionGroups[Region], FactTable[Region], BOTH )
)