One page have different slicers filter different tables

[justinsweet]

I have a page with 4 filters.  Year, Period, Category and Customer. 

When I filter by a specific category, my customer filter results are limited to just the selected category so total categories is 100 and customers is 100,000.  If I select 1 category my customer goes from 100 to 10 (expected).  The first table shows count of customers and sales $   when filtered this is 10, customers $20,000 in sales.  I want a second table that shows for those 10 customers, what are the sales for all of the 100 categories which I would expect to be customer count 10 and sales for those 10 customers of all categories $50,000 dollars since taking in account all 100 categories. 

My issue is I can't get just the 10 customers, it does all 100 customers.  Any thoughts why it doesn't keep the customer filter?  If i go and indivisually select each customer then it filters by that, but if I leave blank even though the filter shows 10 customers, it does all 100 customers. 

[Anonymous]

@Seward12533 I am waiting for IT to update my Power BI to the latest version so I can access your file. But I think I know the issue.

You have edited interactions to not allow it to be filtered by Category right????

Solution

1) First Column SUM(Sales) : This will give sales for the filtered customer for the specific category

2) Second Column: Sum(Sales) using AllExcept Formula by customer id: this will gave sales for the filtered customer no matter what category.

[Anonymous]

@justinsweet link doesnt work

[justinsweet]

---

@Anonymous wrote:

@justinsweet link doesnt work

---

https://drive.google.com/drive/folders/1fMCDwFkoVe8cx4ljr8w0fUZyq0ihVNBo?usp=sharing   i left off a piece of it org.  this should be good

[justinsweet]

---

@Anonymous wrote:

@justinsweet link doesnt work

---

can you try again? @Anonymous

[Anonymous]

Upload it to dropbox or google drive and post the link here.

[Seward12533]

Its hard to tell exactly what is going on without some representative data, any measures your using etc.  

If the masure your using in Table 1 is 

Revenue = SUM(Fact[Sales Amount])

Then the mesure you want to use in table 2 is 

Revenue All Categories = CALCULATE([Revenue],ALL(Fact[Category]))

Note in some situations where you are slicing directly on your FACT table things will not work so I generally create lookup tables that I relate to the FACT table and then slice on those.  Using Category as an example you can use the Create Table button from the modeling tab to create a list of your Categories automatically with this DAX 

Categories = VALUES(Fact[Categories])

You should then set up your slicers on this table (after you relate it to your fact table of course) and then the measure would be 

Revenue All Categories = CALCULATE([Revenue],ALL(Categories[Category]))

[justinsweet]

provided some screen shots below.  maybe this helps

[Anonymous]

Check your relationship and cross filter direction . Make sure the filter direction is from Category to Customer in order to make sure teh filter flows.

Thanks

Raj