Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Table does not respect filter when adding an unrelated measure

So I've got a table set-up that is filtered by a select filter. This now only shows a subset of the records, great! No I'd like to add a non related measure, that gives me some kind of total records for a different and unrelated table. Somehow, this seems to unfilter my table, so that again it shows rows that should not be visible in the current context. Any idea how to remove these rows and let the table reflect the current filter settings. Let me try to illustrate:

 

BooksDownloads
Book A1
Book B5
Book D3

When I try to add the total visitor amount for my website:

BooksDownloadsVisitors
Book A11500
Book B51500
Book C 1500
Book D31500

Is there a way to add the Visitors measure, without causing unwanted rows to show up? Thanks

  • Hi Anonymous,

    Based on my test, you could use the visual filter to filter the blank value:

    Regards,

    Daniel He

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    So I've got a table set-up that is filtered by a select filter. This now only shows a subset of the records, great! No I'd like to add a non related measure, that gives me some kind of total records for a different and unrelated table. Somehow, this seems to unfilter my table, so that again it shows rows that should not be visible in the current context. Any idea how to remove these rows and let the table reflect the current filter settings. Let me try to illustrate:

     

    BooksDownloads
    Book A1
    Book B5
    Book D3

    When I try to add the total visitor amount for my website:

    BooksDownloadsVisitors
    Book A11500
    Book B51500
    Book C 1500
    Book D31500

    Is there a way to add the Visitors measure, without causing unwanted rows to show up? Thanks

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi Anonymous,

    Based on my test, you could use the visual filter to filter the blank value:

    Regards,

    Daniel He

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi Anonymous,

    Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

     

    Regards,

    Daniel He