Forum Discussion

k943's avatar
k943
Helper I
3 years ago
Solved

Creating a measure based on a column from another linked table

I have 2 tables linked together: Employee table and Sales Order table (1:many relationship using Employee ID key and Created by Employee ID key)   I want to create a measure in Sales Order table th...
Need Help
Tips and Tricks
  • HughLa's avatar
    HughLa
    3 years ago

    Hi k943 

     

    Can you try this:

     

    ALL SALES (ASIA) = CALCULATE(SUM(Sales[OrderQuantity]),ALL(Sales),Employee[Country] = "Asia")

     

     

    Hugh

HughLa's avatar
HughLa
Resolver IV
3 years ago

Hi k943 

 

Can you try this:

 

ALL SALES (ASIA) = CALCULATE(SUM(Sales[OrderQuantity]),ALL(Sales),Employee[Country] = "Asia")

 

 

Hugh