DAX Measure result differs due to relationship between tables

[ThxAlot]

Dear gurus,

I came across an problem which drives me up the wall! So I turn for help! Any help is much appreciated!

I wrote a dax measure for running total in a very simple data model. All seems ok as no relationship is established between the dDates table and the fTxn; by accidental, I establish a relationship between these two table, it turned out that the seemingly-right dax measure went WRONG!

I went through quite some articles and posts concerning relationship or filter propagation in Power BI; but still couldn't wrap my head over the issue. Could you pls do me the favor? Tks in advance!

(Attached is the .pbix file)

[Bo_Ry]

I'm very new to DAX.

IMHO,

CALCULATE (
SUM ( fTxn[Qty] ),
FILTER ( ALL ( fTxn[Date]), fTxn[Date] <= MAX ( dDates[Date] ) ))

With [Date] Relationship, fTxn[Date] will has 1 day by filter context from dDates[Date] slicer by Date Relationship direction from dDates => fTxn .



Please use this
CALCULATE (
SUM ( fTxn[Qty] ),
FILTER ( ALL ( dDates[Date] ), dDates[Date] <= MAX ( dDates[Date] ) ))

Same field with the slicer , All override filter context.

[ThxAlot]

I'm very new to DAX.

IMHO,

CALCULATE (
SUM ( fTxn[Qty] ),
FILTER ( ALL ( fTxn[Date]), fTxn[Date] <= MAX ( dDates[Date] ) ))

With [Date] Relationship, fTxn[Date] will has 1 day by filter context from dDates[Date] slicer by Date Relationship direction from dDates => fTxn .



Please use this
CALCULATE (
SUM ( fTxn[Qty] ),
FILTER ( ALL ( dDates[Date] ), dDates[Date] <= MAX ( dDates[Date] ) ))

Same field with the slicer , All override filter context.

Tku so much, Bo_Ry, for walking me through!

If I'm understanding it correctly, the slicer (dDates[Date]) isn't overridden cuz column name of fTxn[Date] in CALCULATE is different, dDates[Date] filtering keeps active into the scope of CALCULATE's evaluation context.