Hello, In BIDS, I'm trying to use Calculated Member Builder to create a new metric. The metric needs to contain 2 values from the same dimension along with a average rate measure. Here is my expression: {([Task].[Task Work Code].&[TASK_A], [Measures].[Avg_Rate]), ([Task].[Task Work Code].&[TASK_B], [measures].[Avg_Rate])} It gives me 'null'. Each one of these Tuples works on it's own, combining them yeilds a NULL What am I doing wrong? thanks, k2

What is the operation you want to do with with measures? Can you post rest part of your query? Avg Rate for TASK A Avg Rate for TASK B Please vote for answer if it helps you.