Forum Discussion

mhr08004's avatar
mhr08004
Frequent Visitor
1 year ago
Solved

Sum measure based on Related Table

Hello all - Please help with this simple issue   Table 1: Mapping Table of City to State Table 2: Contains Sales, City and Month   I have linked these table together via the City fields via a on...
Need Help
mhr08004's avatar
mhr08004
Frequent Visitor
1 year ago

Yes. This works... You have made it clear my data is the issue and not my modeling skill. Thank you!

 

Any thoughts on why my real data would sum ALL OF JAN no matter the state of the sale in every row?

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    1 year ago

    have you created the correct relationshipt between two tables? could you pls share your pbix file?

    • mhr08004's avatar
      mhr08004
      Frequent Visitor
      1 year ago

      I cannot share as the data is propitary and linked form several sources (SnowFlake, DataLakes, and local files) ... I can validate its one simple one-to-many relationsip that links a unique cost_center number to a Sales_Location. Done this a million times... I can also confirm the sales column is Decmil Number so calculations should work... 

    • mhr08004's avatar
      mhr08004
      Frequent Visitor
      1 year ago

      Note - I just deleted all the data connections, re-added the tables, and cut and pasted my measures... Now it works... 

       

      I miss Excel and SQL... lol