Forum Discussion
All except function not working as expected
The problem is that the top level parent customer number field comes from the customer table and not the transactions table. In order to make your solution work I would have to add top level parent customer number field to the transactions table. I'm sure if I do that your soultion will work, but adding a text field to my fact table doesn't seem like a good idea
My bad! I missed that one! Try this!
Measure DAX
Royal Moore Invoice Net Amt =
CALCULATE (
SUM ( Transactions[INVOICE_NET_AMOUNT] * -1 ),
ALLSELECTED ( Transactions ),
VALUES ( Customers[Top ... Number] )
)
You can write also as
CALCULATE(
SUM('Transactions'[INVOICE_NET_AMOUNT] * -1),
ALLSELECTED(Transactions),
Filter(
all('Customers'),
Customers[Top ... Number] = SELECTEDVALUE(Customers[Top ... Number])
)
)
and for line sum with other columns, you can try as
CALCULATE(
SUM('Transactions'[INVOICE_NET_AMOUNT] * -1),
Filter( all('Customers'),
Customers[Top ... Number] = SELECTEDVALUE(Customers[Top ... Number])
)
)
Hope it helps!