When slicer is not chosen show same visuals from different tables

[uniqum47]

Hi, long shot but I thought I ask.

I have a number of disciptivie statistics (age,  state, gender etc; total ~8 visuals) that are filtered by Provider. This model works perfectly fine. But then product owner wants to see all same demographics nationally, independent of provider, things got complicated. Long story short - Without provider same demogaphics need to come from different tables, there is no other way. 

Is there a way that when Provider is not chosen (nothing is on slicer) =  show 8 demographics visuals from Tables of Group b (8 tabels linked), when slicer is chosen - show tables from Group a (another 8 tables linked, but not linked with Group b). All on one page. 

I thought of creating a different tab on visuals, but then it will require explanation why there are 2 tabs... to avoid it - I just wanted Group A of tables to be triggered only when slicer of Provider is chosen.

I feel like there is an easy fix, but no luck so far.

Thanks

[MFelix · Accepted solution]

Hi @uniqum47 ,

Without data is dificullt to give you the correct answer but maybe using the syntax HASONEFILTER on the provider you can make a measure that picks up values from different tables something similar to:

Demographics = IF(
HASONEFILTER(Table[Provider]),
SUM(Table1[Column1]), 
SUM(Table2[Column1])
)