Table does not respect filter when adding an unrelated measure

[Anonymous]

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:

Books	Downloads
Book A	1
Book B	5
Book D	3

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

Books	Downloads	Visitors
Book A	1	1500
Book B	5	1500
Book C		1500
Book D	3	1500

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

[v-danhe-msft]

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

[Anonymous]

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:

Books	Downloads
Book A	1
Book B	5
Book D	3

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

Books	Downloads	Visitors
Book A	1	1500
Book B	5	1500
Book C		1500
Book D	3	1500

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

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

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

Regards,

Daniel He