Forum Discussion

dbltnk's avatar
dbltnk
Frequent Visitor
9 years ago
Solved

How do I calculate something based on values in two different tables?

Hello again,   I'm still working on analytics data from a two-player strategy game.   I have two different, connected tables (connected via an ID). One table knows how often a specific unit was p...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Ya, apologies for screwing these up -- either of these should get you going :)

     

    Total Sets 1 = SUMX(logic_product_unit, DIVIDE(1, RELATED(Units_v025[Units Per Set])))

    Total Sets 2 = SUMX(Units_v025, DIVIDE(COUNTROWS(RELATEDTABLE(logic_production_unit)), Units_v025[Units Per Set]))

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

The thinking with Total Sets was that it too would be a measure.  If you want a calc column there, we would need to tweak it a bit.

 

Errr, which table were you putting in on?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Ya, apologies for screwing these up -- either of these should get you going :)

 

Total Sets 1 = SUMX(logic_product_unit, DIVIDE(1, RELATED(Units_v025[Units Per Set])))

Total Sets 2 = SUMX(Units_v025, DIVIDE(COUNTROWS(RELATEDTABLE(logic_production_unit)), Units_v025[Units Per Set]))

 

 

  • dbltnk's avatar
    dbltnk
    Frequent Visitor
    9 years ago

    Thanks again Anonymous - that worked like a charm! =D