Forum Discussion
Helper IIIunable to reference a field from a table
You cannot reference a "naked" column within a measure. In a measure there is no row context so the engine does not know what row you are referring to. Have a look at this and or this
I would also stick to always using fully qualified names for columns, i.e. TableName[ColumName] instead of just [ColumnName]. The latter is best reserved for referring to measures: [Measure]
Community ChampionHi JimB-GA
Can you show the code where you get the problem and the error message?
Can you, ideally, share the pbix indicating where the problem is?
Helper IIIHi, and thanks for reply. I cannot reference a field from one table to another in calculation.
My objective is to create a measure Total_Cost =[Last] (from Current table)-[New Price] (from Transactions
When I attempt to insert Measure =[Last] in the 'Transactions' table, the error reads
"The value for 'last' cannot be determined. Either 'last' doesn't exist or there is no current row for a column named 'last'.
I have inserted link to file Test.PBIX in dropbox to illustrate.
https://www.dropbox.com/s/z585zgpfbtraiyc/test.pbix?dl=0
Thanks
Jim
- AlB
You cannot reference a "naked" column within a measure. In a measure there is no row context so the engine does not know what row you are referring to. Have a look at this and or this
I would also stick to always using fully qualified names for columns, i.e. TableName[ColumName] instead of just [ColumnName]. The latter is best reserved for referring to measures: [Measure]
v-cherch-msftMicrosoft Employee
Hi JimB-GA
If you want to create a measure,you may use SUM Function as below.Total_Cost=SUM('current'[Last])-SUM(Transactions[New Price]).If it is not your case,please explain more about your expected output.
Measure = SUM('current'[Last])Regards,
Cherie
- JimB-GA
Thanks so much for this solution. Works like a charn..
Jim