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.

     

     

apagan's avatar
apagan
Helper I
9 years ago

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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

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