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 ...
v-lili6-msft
7 years agoCommunity Support
Hi@ AMB_PI
You can use this measure as below:
Measure = sum(Analysis[Underbilled Cost]) / sum(Billing[Revenue])
Result:
Best Regards,
Lin
- sanC7 years agoRegular Visitor
Do this method acceptable to use column reference as an argument??