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
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
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:
Yes, then you should write your formula as below;
A/B instead of A-B/A 🙂
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.
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
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!