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!

  • BhaveshPatel's avatar
    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.

     

     

    • 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