Forum Discussion
Understanding summarizing order lines
I solved it. I'm stupid. I was so convinced all relations were OK, .. BUT there was a relation indicated as "not active". I simply clicked it, and it worked. I don't know why it was not active.
Can you share the data model view and the measure definition please
My fact table has :
DeliveryDate
Property 1
Property 2
Country
ProdCategory
CustomerNo
DeliveryMehod
ItemReferenceNo
+ SUM('salesOrderLines (advanced APIs)'[amount]))
Each column is directly related to its corresponding dimension table using a 1 to many relation.
I use the dimension tables for the filters.
I solved it. I'm stupid. I was so convinced all relations were OK, .. BUT there was a relation indicated as "not active". I simply clicked it, and it worked. I don't know why it was not active.
Thought there might be relationship issues or measure unfiltering. Good to see solved