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

Hi,

Microsoft

## Re: Calculate percentage based on another measure percentage

Hi @aguerreroe,

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

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

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.

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;

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

Frequent Visitor

## Re: Calculate percentage based on another measure percentage

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.

Regular Visitor

## Re: Calculate percentage based on another measure percentage

Hi,

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

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!

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.

Frequent Visitor

## Re: Calculate percentage based on another measure percentage

Hello Pbiozkan,

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.

Announcements