Remove filter on measure without changing result

[Feilin]

I have a measure, with some complex calculations, including some where I manipulate dates on various levels (year, month, days, for instance). I use functions such as ALL() or ALLEXCEPT().

If I show this in a matrix, with years and month on rows, it gives something similar to many tutorials which then go onto, for example, create YTD calculations. However, when I do the same, it gives me a total sum of EVERY value in the measure. I guess this is because of how the YTD function interacts with my FILTERs, etc.

Now, what I would like is a way to treat this measure as a "normal measure", where I can use these YTD functions. Is that possible? I guess, some sort of ALL(), but that works for measures, without affecting the actual values.

I guess one way would be to turn it into a Calculated Column, but that's not practical, because the original table has a lot more rows than dates, and extending the date table seems unnecessarily complex. Rewriting the original formulas are of course also a possibility, but that requires substantial work, since they are quite complex with various levels of SUMs that are computed as variables and then RETURNed at the end. Are there any other ways? Or do the measures simply extend one another, making it impossible to change filters applied at a previous stage? If so, what is the best solution?

[Greg_Deckler]

Would need to see some sample/example data and the calculation that you are using. I have a Quick Measure that calculates differently at differently "levels" within a matrix that might help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Here is the link to the Quick Measure: https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...

[Feilin]

@Greg_Deckler, is it possible to filter on the measure in the way I would like and how?

[Feilin]

Ok, thanks.

So, here's some data. Budget Daily (the one I'm using to apply some different contexts and summarising in the end:

Budget Daily = 
VAR
BudgetMonth =
CALCULATE(
    SUMX(
        ISS
        ;
        ISS[Budget]
    )
	;
    ALLEXCEPT(
        'Dim Date'
        ;
        'Dim Date'[Month Number]
        ;
        'Dim Date'[Year]
    )
	;
	KEEPFILTERS(
		ISS[Account] = "Extra Work Time"
	)
)

VAR
WorkTime =
CALCULATE(
    SUM(
        'Date Extension'[Work Time]
    )
	;
    ALLEXCEPT(
        'Dim Date'
        ;
        'Dim Date'[Day Number]
        ;
        'Dim Date'[Week]
        ;
        'Dim Date'[Month Number]
        ;
        'Dim Date'[Year]
    )
)

VAR
MonthTime =
CALCULATE(
    SUM(
        'Date Extension'[Work Time]
    )
	;
    ALLEXCEPT(
        'Dim Date'
        ;
        'Dim Date'[Month Number]
        ;
        'Dim Date'[Year]
    )
)

VAR
WorkFactor =
    WorkTime
    /
    MonthTime

RETURN
	BudgetMonth
	*
	WorkFactor

Then I just tried to do a TOTALYTD, DATESBETWEEN, and a few others, but they produced similar results, usually the following:

So, is it possible to do a YTD, QTD, and MTD, etc, on the Budget Daily, "as though it were in a table with those values" (ie ignoring filters but retaining the values, even though it is the date filters that give those values...)?