## Desktop

Frequent Visitor
Posts: 8
Registered: ‎07-26-2018

# Column Series / Legend as a Percent of Column Itself?

Hi,

In the screenshot below, I'm trying to overlay "Persona" penetration in a particular product.

So for instance, on the axis I have the Product's penetration (e.g. % of grand total) but in the Legend / Column Series field, I have the Persona. Unfortunately. the percentages come up in the graph as follows:

1.  % = (Total Product 1, Persona A) / (Total Product)

'm looking for...

1. % = (Total Product 1) / (Total Persona A)
2. % = (Total Product 1) / (Total Persona B)
3. % = (Total Product 1) / (Total Persona C)

Any ideas how I can achieve this?

Super User
Posts: 3,947
Registered: ‎01-14-2017

## Re: Column Series / Legend as a Percent of Column Itself?

Hi,

Something like this

=SUM(Data[Value])/CALCULATE(SUM(Data[Value]),ALL(Data[Product]))

Hope this helps.

Frequent Visitor
Posts: 8
Registered: ‎07-26-2018

## Re: Column Series / Legend as a Percent of Column Itself?

HI there,

I created that measure, but not sure how this would help? If I use it column values, the calculatations are not right...

`Measure 2 = sum(Table[Customer ID])/CALCULATE(Sum(Table[Customer ID]),ALL(Table[Product]))`

Highlighted
Frequent Visitor
Posts: 8
Registered: ‎07-26-2018

## Re: Column Series / Legend as a Percent of Column Itself?

Update: maybe this is a better represnetation https://i.imgur.com/QjtEXBa.png

Super User
Posts: 3,947
Registered: ‎01-14-2017

## Re: Column Series / Legend as a Percent of Column Itself?

Hi,

Frequent Visitor
Posts: 8
Registered: ‎07-26-2018

## Re: Column Series / Legend as a Percent of Column Itself?

https://www.dropbox.com/s/muv2a2rugmloujv/Dashboard%20Example.zip?dl=1

Here’s also a visual explanation of why I’m trying to accomplish: https://i.imgur.com/QjtEXBa.png
Super User
Posts: 3,947
Registered: ‎01-14-2017

## Re: Column Series / Legend as a Percent of Column Itself?

Hi,

It works fine.  Here is the result i got.  You may download my file from here.

Frequent Visitor
Posts: 8
Registered: ‎07-26-2018

## Re: Column Series / Legend as a Percent of Column Itself?

Wow, thanks -- this is what I was looking for. The only "issue" is that I lose the product penetration on the y-axis (% of customer grand total)

Super User
Posts: 3,947
Registered: ‎01-14-2017

## Re: Column Series / Legend as a Percent of Column Itself?

You are welcome.  What do you mean by "I lose the product penetration on the y-axis (% of customer grand total)"??

Frequent Visitor
Posts: 8
Registered: ‎07-26-2018

## Re: Column Series / Legend as a Percent of Column Itself?

On the y-axis, I wanted to display the % of total customers that were on that product. That is, SUM (Customers with product A) / SUM(All Customers).

Note that on your file you sent, the % on the y-axis are different than what I originally had.  Unfortunately I'm not sure if it is possible given the structurre that I am seeking -- but I really appreciate your help