Forum Discussion

NicoH's avatar
NicoH
Regular Visitor
4 years ago

Need help on DAX function

Hi everyone I'm confused by the DAX function. I want to compare the budget and contract amount based on a table with the budget and contract info with the columns like BudgetID, Year, Budget Amount,...
Need Help
vojtechsima's avatar
vojtechsima
Super User
4 years ago

NicoH 

ContracetAmountMeasure = 
CALCULATE(
    SUM(Contract[contractAmount]), USERELATIONSHIP(Budget[budgetID], Contract[budgetID]))
NicoH's avatar
NicoH
Regular Visitor
4 years ago

Could you let me know the linked key between Budget and Contract table?