
1. Re: Percentage of Total when Measures are Calculations
Eli Blankers Feb 26, 2016 2:21 PM (in response to christina.lahti.0)Hi Christina,
Unless I'm missing something, I believe this can be solved with a Level of Detail (LOD) calculation. Something to the effect of:
SUM(PageViews)/ {FIXED : SUM(PageViews)}
Let me know if this works.
Cheers,
Eli

2. Re: Percentage of Total when Measures are Calculations
christina.lahti.0 Feb 26, 2016 7:17 PM (in response to Eli Blankers) 
3. Re: Percentage of Total when Measures are Calculations
Ryan Eavey Feb 27, 2016 11:16 AM (in response to christina.lahti.0)The error calculation error will go away if you wrap the LOD calculation with an ATTR() function.
SUM( [Pageviews] ) / ATTR( {FIXED : SUM( [Pageviews] ) } )

4. Re: Percentage of Total when Measures are Calculations
pooja.gandhi Feb 27, 2016 11:38 AM (in response to christina.lahti.0)1 of 1 people found this helpfulHi Christina!
Your current data structure is wide, meaning all the measures are in separate columns instead of tall where the measure names are in one single column with their associated measure values. I think LOD wouldn't work for this example. If you can, it would be best to reshape the dataset before you bring it into Tableau with the structure I described above. Hope that helps.
Pooja.

5. Re: Percentage of Total when Measures are Calculations
christina.lahti.0 Feb 29, 2016 11:29 AM (in response to pooja.gandhi)Thank you! While all answers were helpful (and educational) I marked Pooja's correct because my data is wide and could not be combined the way I had it.
Thanks all for your help!

6. Re: Percentage of Total when Measures are Calculations
Eli Blankers Mar 8, 2016 4:17 PM (in response to christina.lahti.0)1 of 1 people found this helpfulSUM([Pageviews])/AVG( { FIXED : SUM([Pageviews]) } )