cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-danhe-msft Super Contributor
Super Contributor

Re: Table does not respect filter when adding an unrelated measure

Hi @Anonymous,

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

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Anonymous
Not applicable

Table does not respect filter when adding a (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

v-danhe-msft Super Contributor
Super Contributor

Re: Table does not respect filter when adding an unrelated measure

Hi @Anonymous,

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

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-danhe-msft Super Contributor
Super Contributor

Re: Table does not respect filter when adding an unrelated measure

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 279 members 3,179 guests
Please welcome our newest community members: