cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
cs_skit Member
Member

filter all tables by measure?

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

1 ACCEPTED SOLUTION

Accepted Solutions
cs_skit Member
Member

Re: filter all tables by measure?

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.

3 REPLIES 3
Moderator v-qiuyu-msft
Moderator

Re: filter all tables by measure?

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
cs_skit Member
Member

Re: filter all tables by measure?

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.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 353 members 3,584 guests
Please welcome our newest community members: