Can only select both tables filter direction in SSAS tabular

Question

Hi,

I use the same SQL server database to do an import in Power BI Desktop as for my model created in SSAS Tabular SQL Server 2019 with Visual Studio 2019.

My issue is in the create relationships.
In Power BI Desktop I can do:

In Visual Studio I can only select

What did i forget to do?

Answer 1

Hi @Arjan Fraaij [Dynamic Intelligence]

You can refer to this official documentation on Filter Directions.

https://learn.microsoft.com/en-us/analysis-services/tabular-models/bi-directional-cross-filters-tabular-models-analysis-services?redirectedfrom=MSDN&view=asallproducts-allversions&viewFallbackFrom=sql-server-ver16

Best regards,

Percy Tang

---

If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @PercyTang-MSFT

Thanks for your anwser. Only that documentation does explain the use and benenfit of bi-directional cross filtering. I do understand that. Only it does not explain why I can't choose for one-direction filtering bewteen in Many-to-Many relationship.

And also not why there seems to be a difference between Power BI Desktop where this still can be done.

Power BI Desktop Many-to-Many and still I can set a one-direction filtering:

Only not in VS2019 based on SQL Server 2019 SSAS. VS Has one-direction set as default.

So the question is why this difference.

Regards,

Arjan