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

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.

 

Highlighted
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.

Microsoft Implementation for Communities Wins Award

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

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,357)