SUM function only accepts column reference as an Argument

[AMB_PI]

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

[Adeleye11]

Profit Mes = sum(Data[Sales Amount] - sum(Data[Cost Amount]))

[v-lili6-msft]

Hi@ AMB_PI

You can use this measure as below:

Measure = sum(Analysis[Underbilled Cost])   /    sum(Billing[Revenue])

Result:

Best Regards,

Lin

[sanC]

Do this method acceptable to use column reference as an argument??

[Claster]

You missed the bracket.  http://prntscr.com/kmyky5

Try it DIVIDE(Analysis[Underbilled Cost];sum(Billing[Revenue]))

[ShaneP]

I also have the same query about this and the question that why sum fuction only accepts column reference as an argument. Need help for this asap. 

KissAnime groupme letgo