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.

 

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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 495 members 3,878 guests
Please welcome our newest community members: