Return the median value from results calculated by a measure...

[Matty]

Hi,

I've read that MEDIAN and AVERAGE, etc., can only be calculated on data in columns rather than on values returned by a measure. Is this the case or is there a workaround?

Cheers,

Matty

 

[Matty]

Hi,

Another related question:

If I wanted to pass the value returned by the above measure to an IF formula, how would I do this? I've tried a combination of things, but the syntax isn't quite right.

Cheers,

Matty

Bump. Anyone?

Cheers,

Matty

 

[gazpage]

Well the syntax for IF() is pretty straight forward.

IF(logical_test>,<value_if_true>, value_if_false)

You can use TRUE() and FALSE() in dummy versions of the formula to help work out which parts are note working. You can use a measure in an if function easily enough, just put say [Measure]>5. Clearly you need to be quite careful with the syntax, so if you use a measure in a calculated column the measure will be calculated in the context of that row. As ever you can use CALCULATE() to alter the filter context.

 

[Matty]

Thanks for responding, gazpage. I'm fairly proficient with Excel formulas, but I'm still learning DAX syntax. I will continue to read up!

Cheers,

Matty