Forum Discussion

lcasey's avatar
lcasey
Icon for Post Prodigy rankPost Prodigy
7 years ago

Calculate overall Average in a table without filtering

Hello,   I have two tables with 4 fields,   Table 1 (Cases) :    Qty (Gap) and Member   Table 2 (Revenue): Sales (Regularization) and Qty (Gap)   For each member I want to calculate the tota...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi lcasey,

 

Please try this:

Average Revenue = DIVIDE(sum(Revenue[Regularization]),Sum(Revenue[Revenue Gap]))

 

For more advice, please provide sample data and illustrate the desired result with examples. How to Get Your Question Answered Quickly

 

Regards,

Yuliana Gu