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.
Sorry, I need to clarify better, and I really don't understand what you mean.
Here's my table :
The bottom total is perfect. But the totals on each single line are not representing the slicer totals.
I am looking for the beahvior that the column neatly adds up to the total.
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