Forum Discussion

apagan's avatar
apagan
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[Descr...
Need Help
  • BhaveshPatel's avatar
    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.

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I think you should be using RELATED, not RELATEDTABLE.

apagan's avatar
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!