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
Community Championare all these fields from the same table? have you explicitly written a measure? whats the code for return? or is it a column in a table
i wrote a measure for this. doesn't make sense. here is the measure i wrote for the return
return = sum('AdventureWorks Returns Data'[ReturnQuantity])and here is the measure i wrote for the order quantityOrder Quantity =sum('Sales Data'[OrderQuantity])- vanessafvg
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.
