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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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