Forum Discussion
Relationship Many to Many error
CharlesRondo,
You would need to turn off bidirectional cross filtering on your tables, otherwise you are unable to make the above relationship active. For detailed reason, please check my reply in the similar thread below.
https://community.powerbi.com/t5/Desktop/Data-model-loop-cant-point-2-transaction-dates-to-DateTable/td-p/97261
In addition, the measure you create doesn't work as expected. Please share sample data of your tables following guide in the thread below and post expected result here for us to analyze.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Lydia
CharlesRondo,
You would need to turn off bidirectional cross filtering on your tables, otherwise you are unable to make the above relationship active. For detailed reason, please check my reply in the similar thread below.
https://community.powerbi.com/t5/Desktop/Data-model-loop-cant-point-2-transaction-dates-to-DateTable/td-p/97261
In addition, the measure you create doesn't work as expected. Please share sample data of your tables following guide in the thread below and post expected result here for us to analyze.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Lydia