Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hello @VictorMontiel ,
Is there a reality between these two tables?
Thank you
Pragati
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
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.
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!
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |