Problem Statement: Power BI Table Interaction Issue with Account and Opportunity table Visuals

Hi Anonymous - you need to adjust how interactions between the two tables (Accounts and Opportunities) are handled.

you can select the Opportunity Table visual in your Power BI report.Go to the Format Pane, then select Edit Interactions from the ribbon.For the Opportunity Table, ensure that its filtering interaction with itself is set to "None" (represented by a circle with a diagonal line). This prevents the Opportunity Table from resetting when an Opportunity is selected.Create a calculated column or measure in the Opportunity table to filter based on the selected Opportunity.Add this measure as a filter on the Opportunity Table visual.

SelectedOpportunity =
IF(
ISFILTERED(Opportunity[OpportunityID]),
Opportunity[OpportunityID],
BLANK()
)

Apply this measure as a visual filter to the Opportunity Table, ensuring it only shows rows when the OpportunityID matches the selected one.
If the user clicks an Account, ensure the Opportunity Table is still filtered based on the related Account. This should happen automatically due to the one-to-many relationship between Accounts and Opportunities.
No additional steps are needed here unless custom filtering logic is required.Click on an Account in the Account Table and verify that the Opportunity Table displays all Opportunities for that Account.
Click on an Opportunity in the Opportunity Table and verify that it shows only the selected Opportunity while the Account Table updates to display the corresponding Account.

Hope the above steps., helps when clicking on an Account filters the Opportunity Table, and clicking on an Opportunity does not reset the table