Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
AMB_PI
Regular 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 5
Adeleye11
New Member

Profit Mes = sum(Data[Sales Amount] - sum(Data[Cost Amount]))
v-lili6-msft
Community Support
Community Support

Hi@ AMB_PI

You can use this measure as below:

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

Result:

4.png

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Claster
Advocate II
Advocate II

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

 

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

ShaneP
New Member

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.