I have this measure in DAX in a Power BI report:
It it working as expected. It returns the correct result at all three levels of drill-down (StoreID, Project, Employee) on a matrix visual.Code:Count Over 75 = SUMX( SUMMARIZE( 'FactTable', 'Employee'[EmpID], 'Employee'[StoreID], 'Project'[Project], "_Over75", IF([MeasureOfInterest] >= 75, 1) ), [_Over75] )
The data source is an SSAS database.
What would an equivalent measure in MDX be? I am looking to create an MDX Calculated Measure that can be used in Excel. I have tried the below but it is so slow it times out the connection after 20 minutes!
Code:SUM( EXISTING ( [Employee].[EmpID], [Employee].[StoreID], [Project].[Project] ) , CASE WHEN [Measures].[MeasureOfInterest] >= 75 THEN 1 END )


Reply With Quote
