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?

 

  • vojtechsima's avatar
    vojtechsima
    Super User
    4 years ago

    Hi, NicoH 
    There is a non-active relationship between BudgetID and BudgetID ( I can then call it in the measure I sent).

    • NicoH's avatar
      NicoH
      Regular Visitor
      4 years ago

      But it's a many-to-many link.

      • vojtechsima's avatar
        vojtechsima
        Super User
        4 years ago

        NicoH 
        Well, yeah, it's definitely not Ideal, but it did achieve what you wanted.