CREATE MEMBER CURRENTCUBE.[Measures].[Total Patients with Medication]   
AS ( 
-- [Dim Medication].[Medication Code and Name].currentmember.parent , [Measures].[# of Patients with Medication] 
SUM( [Dim Medication].[Medication].currentmember.children 			, [Measures].[# of Patients with Medication] )
) 

-- to count Percent If NULL --> NULL
CREATE MEMBER CURRENTCUBE.[Measures].[% of Patients with Medication]   
AS 
(
 IIF ( [Measures].[Total Patients with Medication] = NULL , NULL  , [Measures].[# of Patients with Medication]  / [Measures].[Total Patients with Medication]   )
)  

SELECT NON EMPTY { [Measures].[# of Patients with Medication]  , [Measures].[Bridge Event Medication Count]
, [Measures].[% of Patients with Medication]
-- , [Measures].[Total Patients with Medication] 
} 
ON COLUMNS
, 
NON EMPTY { (
[Dim Medication].[Medication].ALLMEMBERS
--[Dim Medication].[Medication Code and Name].[Medication Code and Name].AllMembers

) } 
ON ROWS 
FROM [Simply Connect DWH]

SUM( [Dim Medication].[Medication].currentmember.children 			, [Measures].[# of Patients with Medication] )

CREATE MEMBER CURRENTCUBE.[Measures].[Total_Patient_with_medication_by_Eventtype]   AS ( 
	SUM( [Dim Event Type].[Event Type].[All].Children , [Measures].[# of Patients with Medication] )
) 
,  ASSOCIATED_MEASURE_GROUP = 'Bridge Event Medication'
;

CREATE MEMBER CURRENTCUBE.[Measures].[% of Patients with Medication by Event type]   
AS 
(  
IIF ( [Measures].[Total_Patient_with_medication_by_Eventtype] = NULL , NULL  , [Measures].[# of Patients with Medication]  / [Measures].[Total_Patient_with_medication_by_Eventtype]   )
 )