Forum Discussion

Helper I

9 years ago

Solved

New Measure returning error

Ok. This may just be a rookie mistake... I have 2 tables where I am attempting to get a filtered count. Here is what I am using:

Draft = COUNTAX(FILTER(WorkOrders, RELATEDTABLE(FuelTypes[Description])="Diesel"),[WorkOrdersUniqueID])

I am getting an error that indicates that 'Description' in table 'FuelTypes' cannot be determined.

If someone could point me in the right directly, I would truely appreciate it.

Thanks!

BhaveshPatel
9 years ago
You should have a relationship set up between your both tables

RTMO -- RELATEDTABLE travels from Many to one Relationship.
ROM -- RELATED travels from One to Many Relationship.

5 Replies

Anonymous
Not applicable
9 years ago
I think you should be using RELATED, not RELATEDTABLE.
- apagan
  Helper I
  9 years ago
  For some reason, that's giving me a new error message: "The column Fueltype[Description] either doesn't exist or doesn't have a relationship to any table available in the current contenxt"
  
  Draft = COUNTAX(FILTER(WorkOrders, RELATED(FuelTypes[Description])="Diesel"),[WorkOrdersUniqueID])
  
  I am making an adjustment to a current graph, which already is using these 2 tables (FuelType and WorkOrders).
  
  Thanks!
  - BhaveshPatel
    Super User
    9 years ago
    You should have a relationship set up between your both tables
    
    RTMO -- RELATEDTABLE travels from Many to one Relationship.
    ROM -- RELATED travels from One to Many Relationship.