Forum Discussion

SHS's avatar
SHS
Resolver I
6 years ago
Solved

Filtered Row in Query Editor not applying to related Queries

Hello,   I have 2 queries - 1 containing account master data and 1 containing turnover data (with Account ID being the related column). In the account query I have filtered all inactive accounts. H...
General Comment
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi SHS ,

     

    Yes ideally it should work fine.

    Is it possible for you to share your .pbix file after removing any sensitive information?

    Also, can you share screenshot of your data model with relationships between these tables here?

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

SHS's avatar
SHS
Resolver I
6 years ago

Hi Pragati, 

 

Thank you for your quick support. 

 

It seems to work on visuals like charts and diagrams, but it still shows the turnover data in a table, just with empty data in all account master data-related columns - isn't it supposed to be hided from tables as well? 

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi SHS ,

 

Yes ideally it should work fine.

Is it possible for you to share your .pbix file after removing any sensitive information?

Also, can you share screenshot of your data model with relationships between these tables here?

 

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati