Percentage of two data from the same group

[Syndicate_Admin]

Good morning

I am trying to generate a 100% bar chart in which I see the data of a stock, more specifically, the total stock and the percentage of the stock that does not have rotation. I know this data and I have it collected in two columns. The problem is that by incorporating them into the 100% graph, what it does is add up both total values and tell me what the percentage of each one is.

How do I tell you that 100% is the total stock and what I want to know is the percentage on that 100% that represents what has no rotation?

Thank you!

[Syndicate_Admin]

In case it has not been clear, let's imagine that the total stock is 100 kg and I have 10 kg that have no rotation. In this way, I would like the chart to reflect that 10% of the stock has no rotation. However, if I add it to a 100% graph, the graph shows me that the percentage without rotation is 9.09%, because it adds the two values and calculates the percentages on the total, which are 110 kg.

[amitchandak · Accepted solution]

@Syndicate_Admin , You should create a measure

Divide(Sum(Table[No rotation]), Sum(Table[Stock]) )

and use that in bar visual