Forum Discussion
Need help with modeling relational Values
Create relationships between the tables:
Contract Table[Contract] -> Relation Table[Contract]
Contract Table[Contract] -> Relation Table[Successor Contract]Create a calculated column in the Relation Table to get the value of the successor contracts:
Successor Value =
LOOKUPVALUE(
'Contract Table'[Value],
'Contract Table'[Contract], 'Relation Table'[Successor Contract]
)Create a measure to get the predecessor contracts:
DAX
Predecessor Contracts =
VAR SelectedContract = SELECTEDVALUE('Contract Table'[Contract])
RETURN
CALCULATE(
CONCATENATEX(
FILTER(
'Relation Table',
'Relation Table'[Successor Contract] = SelectedContract
),
'Relation Table'[Contract],
", "
)
)Create a measure to get the successor contracts:
DAX
Successor Contracts =
VAR SelectedContract = SELECTEDVALUE('Contract Table'[Contract])
RETURN
CALCULATE(
CONCATENATEX(
FILTER(
'Relation Table',
'Relation Table'[Contract] = SelectedContract
),
'Relation Table'[Successor Contract],
", "
)
)Create a measure to get the values of the successor contracts:
DAX
Successor Contract Values =
VAR SelectedContract = SELECTEDVALUE('Contract Table'[Contract])
RETURN
CALCULATE(
SUMX(
FILTER(
'Relation Table',
'Relation Table'[Contract] = SelectedContract
),
'Relation Table'[Successor Value]
)
)
Community SupportHi PBILix ,
We haven't heard back from you yet, so we're checking in to see if the solution provided by bhanu_gautam resolved your issue. If you have any further questions or need additional assistance, please don't hesitate to reach out.
Your feedback is very important, and we look forward to hearing from you soon.
Thanks.