Forum Discussion

zeke101's avatar
zeke101
Helper II
4 years ago
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...
Need Help
  • zeke101's avatar
    zeke101
    4 years ago

    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]))))
VahidDM's avatar
VahidDM
Super User
4 years ago

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/_ALL

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

 

zeke101's avatar
zeke101
Helper II
4 years ago

Hi VahidDM 

Unfortunately, this measure did not work - Calc is still giving me an "infinity" %

 

I dont have a relationship between the 2 tables. Here is what the relationship Model looks like: