Forum Discussion
struggling with matrix aggregation results
no problem, your relationship between adventure works and the calendar is deactivated, its got a dotted line. you need to double click on it and make it active. that why the relattionship isn't working right now
i wrote a measure for this. doesn't make sense. here is the measure i wrote for the return
those are different tables and you can see there is no relationship between them because the number is the same on each row. you have to create a relationship to join them.
you cannot join a transactional table to a transactional table unless you merge them but you need to know how to join them, what are the common fields between them?
one to many. rolling calendar table joined to sales table and return table. thank you so much for your time.
no problem, your relationship between adventure works and the calendar is deactivated, its got a dotted line. you need to double click on it and make it active. that why the relattionship isn't working right now
Thanks for the replies from vanessafvg and abpgupta.
Hi gvandalay ,
After following vanessafvg's advice and creating and activating the relationship, did you get the desired results, and if so can you mark the reply that helped you as a solution, which will also help members of the community with similar issues. If there are any more questions, please feel free to let us know.
In addition, regarding the creation of relationships, it would be helpful to read the following links:Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Active vs inactive relationship guidance - Power BI | Microsoft LearnBest Regards,
Zhu