You’ll often be tempted to build a CASE WHEN Level calc to get an average monthly calc, but there’s an better way. You'll notice the error when using CURRENTMember and in the client tool doing a multi-select, it doesn't work because it doesn't have a single member to work against - this solution fixes this See below for an example against Adventure Works: with member Measures.MonthlySales as --CASE --WHEN --(EXISTING [Date].[Calendar].Members).Item(0).Level IS [Date].[Calendar].[Mont...

Read More