Forum Discussion
Help in Error: a table with multiple values
Hi HussainWork
In which table are you creating this column?
Hi tamerj1 ,
I'm creating it in the (tags_reading) table as I need to evaluate each reading raw value at that specific [date & time].
HussainWork
Two possibilities. Either you have dupicate tags in at lease one of the lookuptables or you have blank tags in at lease one of the tables.HussainWork
I'm sorry. After having a second look I realized the issue. Actually you are retrieving the single value from the dimention table then use that value to retrieve a value from another fact table. But this will return a table not a single value. In this case LOOKUPVALUE is useless as it returns blank which creates other problems in the subsequent LOOKUPVALUES.
Alternativerly, you can rely on RELATED and RELATEDTABLE. You can utilize CLACULATETABLE to retrieve the table from other fact tables CROSSFILTERing the relationship between the dimention and the other fact table to "Both". In this case you need to provide some sourt of agregation like MAX or MIN.