Obtain percentage of different tables from a table of totals

[VictorMontiel]

Hello all,

I am working on setting up some KPIs for my team to show in the organization.
I have obtained my data from 2 excel files one for incidents caused by changes, other one is a raw file of changes created on the year.

from these 2 files I was able to obtain the 6 different visualization tables, Primary visualization table is "Approved changes"and what I want is to be able to obtain the percentage of other tables related to the total showed in my primary table.

Primary visualization table, total approved changes in the year is 3174

So for example, I have this another table, called Standard changes which is a subtype obtained from the change file.

so the question is, how can I calculate the percentage of each month's and also for total of standard changes against Approved changes from primary visualization table.  example of the total would be: 1947/3174*100 = 61%

thanks!

Victor.

[Pragati11 · Accepted solution]

Hello @VictorMontiel ,

Is there a reality between these two tables?

Thank you

Pragati

[Pragati11 · Accepted solution]

Hello @VictorMontiel ,

Is there a reality between these two tables?

Thank you

Pragati

[VictorMontiel]

Hi, Pragati. I made a relationship on business service field, so I could add a filter at the top.

here's how it all looks.

best.

[v-xuding-msft]

Hi @VictorMontiel ,

Is Pragati11's answer helpful?  If it is, kindly accept it as a solution. More people will benefit from this thread. If you are still confused about it, please share more details to us.  Thanks!

[Pragati11 · Accepted solution]

HI @VictorMontiel ,

As you have got relationship between these 2 tables, you can create a caluclation somehting like below:

Measure = DIVIDE(SUM(TBALE1[ApprovedChnages]), SUM(Table2[Standard]), 0)

Replace your tablenames and column names in above dax.

Thanks,

Pragati

[VictorMontiel]

thanks, Pragati.

your suggestion helped me to find a way to put all the info in a single table.
what I did was to create additional columns per each KPI I want to show, with values 1, 0 post that I was able to put them all together in a single table with their respective percentages.

here's how it looks.