This content has been marked as final.
Show 3 replies
-
1. Re: Comparing measures to different levels of a hierarchy
Abhilash Sharma Nov 9, 2017 11:37 AM (in response to Peter Kosztolanyi)3 of 3 people found this helpfulHi Peter,
Yes, there is an easy way to do this via Level of Detail expressions.
Please follow the below steps and it will help you in achieving the desired output:
Step 1: Create Share of Country Sales Calculated Field as below:
{ FIXED [City] : SUM([Sales])} / { FIXED [Country] : SUM([Sales])}
Step 2: Create Share of Continent Sales Calculated Field as below:
{ FIXED [City] : SUM([Sales])} / { FIXED [Continent] : SUM([Sales])}
Step 3:
Change the display format of both of these fields to Percentage.
Output:
Hope this helps.
-Abhilash
-
2. Re: Comparing measures to different levels of a hierarchy
Peter Kosztolanyi Nov 9, 2017 1:53 PM (in response to Abhilash Sharma)wow it cannot be more precise answer. you really took the effort to explain it and really highlighted my gap of my knowledge in LOD expressions. many thanks
-
3. Re: Comparing measures to different levels of a hierarchy
Abhilash Sharma Nov 9, 2017 8:48 PM (in response to Peter Kosztolanyi)No problem Peter.
I'm glad I was able to help.
-Abhilash