Using a measure within a dax statement where the measure ignores current filters

[Anonymous]

I'm trying to figure out how to do this. I feel like it should be simple and straight forward but having troubles locating the syntax to complete it.  I have a need to make use of an existing measure, but within the Dax statement i need to use the measure without filters.

Is there something equivilent to (as the below isn't actually correct):

= All([MeasureName])

Essentially i need "This measure, but without filters" that i can use within a dax statement

[Phil_Seamark]

Hi @Anonymous

Do you have the code for the existing measure you are trying to do this to?

eg, if your existing measure is something like

existing measure = SUM(Table[Column])

then you can just copy the expression used and wrap a CALCULATE and filter around it

like this

new measure = CALCULATE( SUM(Table[Column]) , ALL(Table))

[Anonymous]

Thanks for the reply @Phil_Seamark.  Essentially thats down the line of the solution i've come up with so far.  I was wondering if there was a much more simplier, cleaner solution.

In my case it isn't just a simple measure.  I'm writing a [Revenue per FTE] measure and need a [SumMax Revenue Per FTE]
In this instance i'm lucky as the calculation is simply: Divide([Revenue], [FTE])

So i've had to take all of the dax code that makes up [Revenue] and [FTE] and placed that into [SumMax Revenue Per FTE]

I just know there will be an occasion down the track whereby i'll have created some very complex Measure and i'll need to perform an operation on it that won't be so clean to write into a single dax statement.

[v-shex-msft]

Hi @Anonymous,

Did you try to directly use measure in calculate?  (E.g. Calculate([Measure], All(Table)))

In addition, some functions which contain the filter can effect on measure, you can use all function in these filter to ignore the current filter.(for example: SUMX, AVERAGEX,COUNTX...)

BTW, I'd like to suggest you use the way which Phil_Seamark metioned, if you use filter in combination, the measure may get the wrong result.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @v-shex-msft,  Calculate can't use a measure for the expression parameter.

[v-shex-msft]

Hi @Anonymous,

Perhaps you can take a look at below article:

Optimizing DAX expressions involving multiple measures

Regards,

Xiaoxin Sheng

[Anonymous]

What a great looking article!  I'll have a read now.