There are 2 typical workarounds in case when you need some functionality that is present in MDX but is not available in SSAS Entity Framework Provider:
- Create a calculated member in a cube
- Call raw MDX using our AdomdExtensions library which allows to execute MDX and map ADOMD.NET result recordset into .NET objects mapping MDX hierarchical names to .NET property names.