cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aguerreroe Frequent Visitor
Frequent Visitor

Calculate percentage based on another measure percentage

Hello,

Maybe somebody can help me. I´m trying to calculate the percentage of the turnover that fills out certain conditions with the total of incomes.

 

For doing this I have a column with all the turnover and another column with different conditions. 

What I want is to sum up the turnover for the rows who meet these conditions and find the average of the total.

 

Can somebody help me?

 

Thank you

A. G. 

14 REPLIES 14
pbiozkan Regular Visitor
Regular Visitor

Re: Calculate percentage based on another measure percentage

Hi,

 

Please share your 2 columns so I can help with your formula.

Microsoft v-jiascu-msft
Microsoft

Re: Calculate percentage based on another measure percentage

Hi @aguerreroe,

 

Please share a dummy sample.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
aguerreroe Frequent Visitor
Frequent Visitor

Re: Calculate percentage based on another measure percentage

Hello,

I sent the example.

In the first image you will find a chart with total values.

 

power2.PNG

 

The second file enclosed is a chart based on the previous one, but filtered

 

power1.PNG

 

And what I´m looking for is a way to calculate the percentage for each value related to the the total.

I can´t figure out a way to do this.

 

Thank you

Best Regards

A.G.

 

pbiozkan Regular Visitor
Regular Visitor

Re: Calculate percentage based on another measure percentage

Hi,

 

You can use below and if you'd apply filter, it will calculate percentage with filter;

 

 

First, add some total sums;

 

1. Total 2018= sum(prima 2018)

2. Total 2017= sum(prima 2017)

3. Total 2016= sum(prima 2016)

 

if you need total of 3 years add Total 2018 + Total 2017 T Total 2016 and name it as Ultimate Total

 

4. All formula= Calculate((total 2018), all (mes))

 

5. All Mes= Total 2018/All formula

 

or find percentage for 3 years=

 

Ultimate Total Percentage= Total 2018/ Ultimate Total or,

                                             Total 2017/ Ultimate Total or,

                                             Total 2016/ Ultimate Total

 

 

 

aguerreroe Frequent Visitor
Frequent Visitor

Re: Calculate percentage based on another measure percentage

Thank you for your reply,

but I think I have explain me wrong. Technically what I need is to divide the result of a filter concerning the same amount without filtering.

I the example I want a way to divide:

Mes1 Prima 2016 (Total amount) / Mes1 Prima 2016 (filtered amount)

or what is the same numerical:

 

86.369,60 / 198.821,96 

 

to find:

 

0,4344

or:

43,44%

 

Thank you

Best Regards

A.G.

pbiozkan Regular Visitor
Regular Visitor

Re: Calculate percentage based on another measure percentage

Hi,

 

Ok, could you please replace all with allselected? That'll do i hope.

aguerreroe Frequent Visitor
Frequent Visitor

Re: Calculate percentage based on another measure percentage

Do you mean to change:

 

All formula= Calculate((total 2018), all (mes))

 

to

 

All formula= Calculate((total 2018), allselected (mes))?

 

I´ve tried to do it,, but the output is the same.

 

Thank you!

pbiozkan Regular Visitor
Regular Visitor

Re: Calculate percentage based on another measure percentage

Yes, with all selected formula, you need to apply a filter and choose the years or months to be applied. If you want to see the 2016/(2017+2018) you need to select 2017 and 2018 in a filter.

aguerreroe Frequent Visitor
Frequent Visitor

Re: Calculate percentage based on another measure percentage

Hello Pbiozkan,

thank you for your support!!!

Smiley Wink

 

But something is not working.

 

The equation is very simple

 

X= (A-B)/A

 

In this case "A "should be the total amount "Prima 2016" 

and "B" what was filtered in the previuos visualization 

 

So for example for 2016 the complete year should become the next output:

 

0.3851 = (3.555.318,73 - 2.185.858,60) / 3.555.318,73

 

What do you think?

Best Regards

A.G.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)