Forum Discussion
zeke101
Helper II
Helper IIPercentage Calculation from 2 tables
Hey Guys, I'm requesting some help on building this measure.... I have 2 tables (an Events table and Rejects Table). The Events table contains the total number of events that occurred for a cer...
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]))))
zeke101Helper II
Helper IIHi 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.
VahidDM
Super User
Super UserHi 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/_ALL
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!