Forum Discussion
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:
| 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
Hi Anonymous,
Based on my test, you could use the visual filter to filter the blank value:
Regards,
Daniel He
3 Replies
- AnonymousNot 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:
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
Microsoft Employee
Hi Anonymous,
Based on my test, you could use the visual filter to filter the blank value:
Regards,
Daniel He
- v-danhe-msft
Microsoft 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