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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

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.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.