Convert Measure to Set?

Questions & Answers
1

I am trying to figure out the standard deviation of a calculated measure. Is there a way to feed the stdev function all of the valid (non empty) calculated members? The below formula is not working.

Stdev(
Filter(Descendants([Time].Members),
not IsEmpty([Measures].[MyCalcMeasure])
),
[Measures].[MyCalcMeasure]
)

2

Hi @anth120

Where (rows, columns, pages) and how do you use “Time” dimension in report?
And how do you calculate the “MyCalcMeasure” precisely?
When you say “below formula is not working” - could you please ellaborate?

Martins / eazyBI