How to show certain data always and let the filter affect the other half.

Question

Hello,I am working on a problem where I am trying to geogrphically map the Ecom Accounts Vs the Retail Accounts.&nbsp;I want to always show the Ecom data and against that i want to select the Retail account the get filtered based on the Salesperson. How do I go about to achieve this. All my data is in a invoice table where I have flagged the accounts as Retail and Ecom. Since the Salesperon has no Ecom Accounts, they keep disapperaing as select a Salesperson.&nbsp;How can I make the Ecom data always available ? How do I make sure the row level secutiry also doesn't affect it ?

greg_deckler · Answer

Anonymous&nbsp;Difficult to know for sure without something to test with but in general the answer to these kinds of problems lies in creating a disconnected table for your filter (Sales Person for example) and then construct your measure so that it forms the appropriate relationship between the tables. It's a variation of the Disconnected Table Trick: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563

anonymous · Answer

Hi Anonymous&nbsp;,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly&nbsp;&nbsp;
Regards,
Xiaoxin Sheng

anonymous · Answer

Hello,I have plotted the Sales on the map and distingushed them based on Account Flag - Ecom and Retail.When I filter a Salesreps it only shows Invoiced Sales associated to the sales rep. I want to make sure that the Ecom Flagged Invocied Sales always show&nbsp; and the rest of the Retail Flagged Invocied Sales get filtered based on the Salesrep selected.&nbsp;This kind of helps me compare as to what is selling on Ecommerce overall vs Retail for the selected Salesrep.It's a way a Salesrep can see as to what they are selling in the region agaisnt what is selling on Ecommerce overall. Do you think I will need to separate the Invocied Sales into two tables ? But if I do that I wont be able to plot it on one map.&nbsp;Let me know if you need more information.

anonymous · Answer

Hey Greg,Thank you so much. This is the approach&nbsp; I tried but it works very slowly. I am getting result but at the zipcode level it doesnot render.

lbendlin · Answer

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).Do not include sensitive information or anything not related to the issue or question. Trim your data down to just the issue.If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216 Please show the expected outcome based on the sample data you provided. Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Forum Discussion

How to show certain data always and let the filter affect the other half.

5 Replies

Related content

Report Refresh Time always Wrong

Need DAX Measure to Always Return Constant Result Despite Page Level Filter selection

Filter always on

Filter

View report option always enable