Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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] )
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] ) )
However, this throws an error, stating that sum only takes a column reference...
How would I go about this?
Kind regards
Solved! Go to Solution.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.