cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chefe
Helper II
Helper II

SUM only accepts column ref

Hi there

 

I have DAX code for a one-column ("a") calculated table. See code and screenshot below.

 

SELECTCOLUMNS(
	ADDCOLUMNS(
		SUMMARIZE(
			FILTER(
				'Market data - Fx rates TTM'
				;'Market data - Fx rates TTM'[Fx ccy]="CNH"
				&& 'Market data - Fx rates TTM'[Spot/outright]="Spot"
				&& 'Market data - Fx rates TTM'[Quote type]="Mid"	
			)
			;'Market data - Fx rates TTM'[Fx date]
		)
		;"x=CNH";[EUR/CNH]
	)
	;"a"
	;[x=CNH]
)

2017-02-02 16_31_49-.png

 

What I want to do is SUM the values of this column, i.e. Measure = sum(calculated_table[a]).

 

BUT, I want to do this all _in memory_, without the need of an intermediate calculated table... therefore I went ahead and put this code into a SUM function directly 

 

sum a:= SUM(
	SELECTCOLUMNS(
		ADDCOLUMNS(
			SUMMARIZE(
				FILTER(
					'Market data - Fx rates TTM'
					;'Market data - Fx rates TTM'[Fx ccy]="CNH"
					&& 'Market data - Fx rates TTM'[Spot/outright]="Spot"
					&& 'Market data - Fx rates TTM'[Quote type]="Mid"	
				)
				;'Market data - Fx rates TTM'[Fx date]
			)
			;"x=CNH";[EUR/CNH]
		)
		;"a"
		;[x=CNH]
	)
)

2017-02-02 16_32_50-.png

 

However, this throws an error, stating that sum only takes a column reference...

 

How would I go about this?

 

Kind regards

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

2 REPLIES 2
Sean
Community Champion
Community Champion

@chefe  try SUMX instead

@Sean Thank you! Didn't think of that!

Cheers

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.