Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi @Anonymous,
Based on my test, you could use the visual filter to filter the blank value:
Regards,
Daniel He
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
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
User | Count |
---|---|
98 | |
91 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |