Azure analysis service many to many relationship

[Sachinss]

hi all,

Hi All, I am converting report from Import mode to Azure analysis services mixed mode and having strange issue with many to many relationships between 2 dataset In my tabular model.

In my raw data with table visual with both dataset columns included, I see data from 1 dataset only instead of complete data from both dataset. 

However all other measures works fine on pages with both dataset .

I also tried to convert many to many into 1-M relationship by creating bridging table but doesn't tasted any luck.

Can anyone suggest if faced such situation earlier. Kindly suggest.Due to security reason cannot upload model. 

@Amit c

[amitchandak]

@Sachinss , We try to Many to Many Tables fact we use common/dimension tables to resolve that.

But if one of them has to act as dimension , we just use many to many with filter direction from dim -> fact 

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...