filter all tables by measure?

[cs_skit]

I have a "databaseID" in every table that gives me the same data for multiples "accounts" over all 25 tables.

The database should be selectable in a slicer only one: I give 0 if none or ALL selected as slicer does not currently force that

Selected Database = IF(COUNTROWS(ALLSELECTED(Databases))=1; ALLSELECTED(Databases[DatabaseID]);0)

This works like on a card it correctly shows the selected databaseID.

What I would like now is filter all 25 tables by something like "WHERE DatabaseID = [Selected Database]".

Currently the only thing that works is if I bake the databaseID into all my constructed table references so my constructed "GUID" includes the DBid. I thought it should be possible to mabye like include 25 report level filters but when I try something like one per table to check IF DBid = [Selected Database] the measure is 0 in that context. I think the ALLSELECTED is the issue? 

EDIT: OK just learning some DAX and it seems I am doing it wrong... seems I have to include it in my GUIDs as I already stated so I have the relation by dbID in all my tables

[v-qiuyu-msft]

Hi @cs_skit,

Did you solve the issue by yourself? If not, please share some sample data and screenshots about desired results for our analysis.

Best Regards,
Qiuyun Yu

[cs_skit · Accepted solution]

Oh yes sorry forgot about this thx for the reminder.

So after some research and experimenting I decided this is not the way its meant to be. The solution with baking it into all my table keys and therefore all relations works but it comes with some inherent disadvantages thats not worth the trouble imho. Like for examples some DAX is more complicated that way and theres worse user experience and standard functionality like cortana QA and quick insight givesmore ridicolous results and also no way to change filter in dashbord.

I decided to provide the different dataset filtered in my SQL and deploy them as different reports. If I get a customer where thats not possible or who explicitly wants it (after having communicated the disadvantages) I'll do it with my constructed keys.

Maybe some day when theres more functionality with global filter in dashboard and global variables, ideas that are already in the ideas hub then I put it in my default.

[cs_skit]

these are the two ideas I mentioned:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/14950908-add-global-variables-to-...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6674820-global-filter-in-dashboar...