Forum Discussion

AMB_PI's avatar
AMB_PI
Regular Visitor
7 years ago

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-msft's avatar
    v-lili6-msft
    Community Support

    Hi@ AMB_PI

    You can use this measure as below:

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

    Result:

    Best Regards,

    Lin

    • sanC's avatar
      sanC
      Regular Visitor

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

  • 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

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