Why these 2 measures give a different total?

[Anonymous]

I have only these 2 measures in a visual:

Measure 1:

VAR V1=
ADDCOLUMNS(
VALUES (Fact[Key_Customer] ), 
"C1",             
CALCULATE([RevenueYTD],SAMEPERIODLASTYEAR('Date'[Date]),REMOVEFILTERS(Fact[Segment],Fact[Type])
)  
)

RETURN SUMX(V1, [C1])

Measure 2:

CALCULATE ( [RevenueYTD], SAMEPERIODLASTYEAR('Date'[Date]) )

I use Measure 1 mostly, because I am preventing certain splits, that I prefer grouped by Customer….

My question is: why do I get 2 different TOTALS?

(I expected to see the totals as exactly the same. For the above case; I have no filter, its just a clean matrix visualization with both measures as ‘Values’!)

[dedelman_clng]

Hi @Anonymous -

Hard to tell specifically without the model, syntax for [RevenueYTD] or any data, but at first glance you do a REMOVEFILTERS in the first one and not on the second one. 

Hope this helps

David