Measure different from Total

azakir,

Personally I would re-write the measure to not use the time intelligence functions, like this:

Measure =
VAR MaxDate = MAX ( 'Calendar'[Calendar Date] )
VAR MinDate = MaxDate - 7
VAR Result =
CALCULATE (
    SUM ( Benchmarks[Benchmark Value] ),
    'Benchmark Measure'[Benchmark Measure Code] = "BCM", 
    'Benchmark Type'[Benchmark Type Description] = "Schedule 1MS",  
    REMOVEFILTERS ( 'Calendar' ),
    'Calendar'[Calendar Date] > MinDate,
    'Calendar'[Calendar Date] <= MaxDate
)

RETURN Result

I find it's a lot more explicit written this way and easier to debug, for me personally.

If that doesn't work for you, can you please share a sample pbix file? (If you don't know how, please check the pinned thread in the forum.) It would make debugging your issue easier. 🙂

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.