Forum Discussion

SHS's avatar
SHS
Icon for Resolver I rankResolver 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. However, the turnover data still shows turnover for the inactive accounts. 

 

I have a Many to One-relationship with a both cross-filter direction (I have tried to change every possible option for both of these without result). 


Can anyone tell me, why this is the case?

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

3 Replies

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    Hi SHS ,

     

    In edit query you will not see any cross-filtering between these 2 tables.

    But when you create a visualisation, the data will get cross-filtered - so displaying only those with ACTIVE accounts.

    Try moving your data to a visual and check.

     

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

     

    Thanks,

    Pragati

    • SHS's avatar
      SHS
      Icon for Resolver I rankResolver 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
        Icon for Super User rankSuper 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