Why these 2 measures give a different total?

Anonymous — Thu, 30 Sep 2021 12:39:26 GMT

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’!)

Re: Why these 2 measures give a different total?

dedelman_clng — Thu, 30 Sep 2021 14:15:03 GMT

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

topic Why these 2 measures give a different total? in DAX Commands and Tips

Why these 2 measures give a different total?

Re: Why these 2 measures give a different total?