Forum Discussion
Solved
Percentage 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]))))
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]))))