I am running a query against two different measure groups. I'm using Non Empty. Can I use something in the WHERE clause to block results where one of the measures is null?
In the following query I'd like to return only rows with non null Prc Net Weight:
MEMBER [Measures].[Weight Calc]
AS [Measures].[Coil Weight] + [Measures].[Prc Net Weight]
View Complete Post