lternate to work with ambiguous relationships through dax

[Anonymous]

Hi,

Is there any way through dax where I can avoid the duplication of table , so as to prevent cardinality.

Actually,I have a huge data, so I am avoiding to duplicate the tables to make the relationships work. Do you please can suggest where I can  do this through DAX.

Thanks in Advance

[kentyler]

You can create relationships in DAX code. Can you post a small sample power bi file. Or describe the tables you want to create relationships among ?  If you'd prefer to do a screen share where you can explain your problem in more detail, email me ( ken@8thfold.com) with a good day and time and we can look at them together.

I'm a personal Power Bi Trainer I learn something every time I answer a question

The Golden Rules for Power BI

1. Use a Calendar table. A custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. https://www.youtube.com/watch?v=FxiAYGbCfAQ
2. Build your data model as a Star Schema. Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! https://www.youtube.com/watch?v=1Kilya6aUQw
3. Use a small set up sample data when developing. When building your measures and calculated columns always use a small amount of sample data so that it will be easier to confirm that you are getting the right numbers.
4. Store all your intermediate calculations in VARs when you’re writing measures. You can return these intermediate VARs instead of your final result  to check on your steps along the way.