question

Synerverse-0694 avatar image
0 Votes"
Synerverse-0694 asked ShaikMaheer-MSFT commented

Percentage of Parent for any deminsion in DAX

What is the equivalence in DAX for percentage of parent for any dimension? I have it for MDX but need the DAX version. Here is the MDX version

WITH MEMBER [Percentage of Parent Sales] AS

CASE
WHEN IsEmpty([Measures].[Sales]) THEN 0
ELSE
IIF
(
IsEmpty(Axis(1).Item(0).Item(0).Dimension.CurrentMember.Parent),
1,
[Measures[Sales] / (Axis(1).Item(0).Item(0).Dimension.CurrentMember.Parent,Measures.Sales)
)
END





azure-analysis-services
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Synerverse-0694 ,

Following up to check is below provided answer helps you? If yes, Please Accept Answer. Accepting answer helps community as well. Please let us know if any further queries. Thank you.

0 Votes 0 ·

Hi @Synerverse-0694 ,

Just checking is below provided answer helps you? If yes, Please Accept Answer. Accepting answer helps community as well. Please let us know if any further queries. Thank you.

0 Votes 0 ·

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered

Hi @Synerverse-0694 ,

Welcome to Microsoft Q&A Platform. Thank you for posting query here.

Kindly check below Article for Percentage of Parent in DAX
https://analytics-blog.com/2015/01/18/percent-of-parent-in-hierarchy-dax/

Also, check similar thing discussed here.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/663184f4-88b1-4705-bcf8-d35e34884d86/percentage-of-parent-for-all-dimensions?forum=sqlanalysisservices


Below are the useful links which helps to convert MDX to DAX. Please see.
https://bistuffwithdigven.wordpress.com/2012/07/25/convert-mdx-into-dax-part1/
https://www.sqlbi.com/articles/converting-mdx-to-dax-first-steps/

Hope this may help. Please let us know if any further queries.


  • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.