cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pbiozkan Regular Visitor
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

aguerreroe Frequent Visitor
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

Highlighted
pbiozkan Regular Visitor
Regular Visitor

Re: Calculate percentage based on another measure percentage

Yes, then you should write your formula as below;

 

A/B instead of A-B/A 🙂

 

 

aguerreroe Frequent Visitor
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.

 

pbiozkan Regular Visitor
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.

 

then, add another measure;

 

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

 

pct of all selected= total 2018/ allselected2018

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,540)