The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
I have 2 tables, both tables are connected on EnvironmentName column and I have selected cross filtering on Both direction.When I select an EnvironmentName in Table A it filters correctly on Table B. Please see the screenshot attached below. However, when I select an EnvironmentName from Table B, it displays blank in Table A.
When I select an EnvironmentName in Table A it filters correctly on Table B. Please see the screenshot attached below.
However, when I select the same EnvironmentName in Table B, it displays blank in Table A.
Can someone please tell me what's the issue here? Thanks!
Solved! Go to Solution.
Hi @sonam7 ,
I find that the record (1) in Table B you choose to cross filter Table A is not the same as the record (2) cross filtered by Table A. And record (1) does not have matched recordes in Table A. This is the most likely cause of your problem. If not, please give me more details so that I can help you better.
Best Regards,
Icey Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @sonam7 ,
I find that the record (1) in Table B you choose to cross filter Table A is not the same as the record (2) cross filtered by Table A. And record (1) does not have matched recordes in Table A. This is the most likely cause of your problem. If not, please give me more details so that I can help you better.
Best Regards,
Icey Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.