Forum Discussion
Percentage Calculation from 2 tables
I did a little bit of research and found a measure that works.....
Rejects as a % of Event Volume =DIVIDE('Key Measures'[Total Reject Vol],CALCULATE(Sum('Events All'[COUNT(*)]),FILTER('Events All','Events All'[Client ID & Site ID]=SELECTEDVALUE(Rejects_All2[Client ID & Site ID]))))
Hi zeke101
If you want to find the % of Rejectes based on the All Events, Try this:
Measure = COUNTROWS(Rejects_All2)/COUNTROWS(Events All)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi VahidDM
This wont work as it only counts the rows of the table, but each row value is worth more than 1. Notice how the tables have a "Count (*)" column. Those numbers need to be aggregated and then a calculation must be derived to create the percentage.
Hi zeke101
Is there any relationship between those tables? if yes, which columns are connected to each other?
Try this measure:
Rejects as a % of Event Volume =
Var _ALL =SUM(Rejects_All2[COUNT(*)])
Var _REJ = SUM('Events All'[COUNT(*)])
return
_REJ/_ALLIf this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!