cancel
Showing results for
Did you mean:
Regular Visitor

## Re: Calculate percentage based on another measure percentage

Hi,

if you want to find the percentage of 2 in 5, you should use 2/5 directly. However, if you'd like to see the drop or increase; 2-5/5.

So, if you'd like to see the increase/decrease percentage in 2018, you should use 2018 value-2017 value/ 2018 value

if you'd like to see "what does 2017 sales mean in my total sales" you should use 2017/all sales

Hope that helps

Highlighted
Frequent Visitor

## Re: Calculate percentage based on another measure percentage

Hello,

I´m not comparing sales of different years. I´m comparing sales in the same year, but earned in a specific distribution channel.

Imagine that you have a total amount of 1000 euros.

200 Euros through website direct sales

200 Euros through phone direct sales

and

600 Euros through dealers indirect sales

Now I create a visualization only with direct sales (excluding with a filter in the visualization indirect sales)

and I want to include in this visualization the % that represent this 400 euros compared to the total amount of 1000.

Something like this:

Amount  Perc.

400         40%

Thank you

Regular Visitor

## Re: Calculate percentage based on another measure percentage

Yes, then you should write your formula as below;

Frequent Visitor

## Re: Calculate percentage based on another measure percentage

Yes,

the point is how can I do this in PowerBI,

because if I divide A/B I will become 1

Measure = Prima 2016/Prima 2016

Measure = 1

my problem is that I have to include the filters in the equation and I don´t know how to do this.

Regular Visitor

## Re: Calculate percentage based on another measure percentage

ok;

those formulas from previous post:

1. Total 2018= sum(prima 2018)

2. Total 2017= sum(prima 2017)

3. Total 2016= sum(prima 2016)

now we have sum of all years individually. add totals to your table. put a slicer for years and select 2018.

Allselected2018=Calculate((total 2018), allselected (mes))

pct of all selected= total 2018/ allselected2018

Announcements

#### New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

#### Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,413)