New Measure returning error

[apagan]

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!

[Anonymous]

I think you should be using RELATED, not RELATEDTABLE.

[apagan]

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 · Accepted solution]

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.

[apagan]

Thanks for the clarification, Bhavesh.  I was wondering what the difference was between the two.

[v-yulgu-msft]

Hi @apagan,

Related function returns a related value from another table. While relatedtable function returns a table of values. This function is a shortcut for CALCULATETABLE function with no logical expression.

Thanks,
Yuliana Gu