Forum Discussion
AMB_PI
7 years agoRegular Visitor
SUM function only accepts column reference as an Argument
Hi There,
I have two columns in two differnet Tables
Table 1 : Analysis & Column Name : Missed Revenue
Table 2 : Billing & Column Name : Revenue
I want a Card to hold the percentage of 'Missed Revenue/Revenue'
I tried to create a measure to solve this :
Measure = sum(Analysis[Underbilled Cost]/sum(Billing[Revenue]))
but am getting error as ' SUM function only accepts column reference as an Argument '.
Alternatively, if this is wrong approach can anyone please direct me to how to solve this aother way.
Thanks,
AB
5 Replies
- v-lili6-msftCommunity Support
Hi@ AMB_PI
You can use this measure as below:
Measure = sum(Analysis[Underbilled Cost]) / sum(Billing[Revenue])
Result:
Best Regards,
Lin
- sanCRegular Visitor
Do this method acceptable to use column reference as an argument??
- ClasterAdvocate II
You missed the bracket. http://prntscr.com/kmyky5
Try it DIVIDE(Analysis[Underbilled Cost];sum(Billing[Revenue]))
- ShanePNew Member
- Adeleye11New MemberProfit Mes = sum(Data[Sales Amount] - sum(Data[Cost Amount]))