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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Kudoed Authors