07-26-2018 06:50 PM
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:
- % = (Total Product 1, Persona A) / (Total Product)
'm looking for...
- % = (Total Product 1) / (Total Persona A)
- % = (Total Product 1) / (Total Persona B)
- % = (Total Product 1) / (Total Persona C)
Any ideas how I can achieve this?
07-26-2018 09:28 PM
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]))
thanks for your time
07-29-2018 01:06 PM
Here’s also a visual explanation of why I’m trying to accomplish: https://i.imgur.com/QjtEXBa.png
07-30-2018 06:14 PM
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