This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 87%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
need help to rewrite this SSAS MDX Query without Axis Function cause Axis is not supported in Power BI. Using a tabular cube is not a option for me.
CASE WHEN
ISEMPTY( [Measures].[Return @Retail] )
THEN
0
ELSE
IIF(
ISEMPTY( Axis(1).Item(0).Item(0).Dimension.CurrentMember.Parent )
,1
, [Measures].[Return @Retail] / ( Axis(1).Item(0).Item (0).Dimension.CurrentMember.Parent, [Measures].[Return @Retail] )
)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 95%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
This is not a query, this is a definition of a calculated member, probably in the Measures dimension. The member calculates the ratio-to-parent for the first attribute that the user put on rows in an actual MDX query when using the cube.
Unfortunately, the Axis function is the only way to tell the engine to check this query-time user's choice. Since your client doesn't support it, you'll have to come up with a supported functional equivalent, which will most probably be less universal than what the Axis function allows.