Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Circular Dependencies

Equity Purchase = VAR A =     IF(         'Deal Apr 15- Sep15A'[DL_CLASS] = 1 &&         'Deal Apr 15- Sep15A'[DEAL_CD] = 4 &&         'Deal Apr 15- Sep15A'[INSTR_SUB_TYPE] IN {"EQ", "EU", "NC"...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Problem Solved.

    Instead of creating calculated columns, I have created measures.
    Like this.
    Equity Purchase Measure =
    VAR A =
    IF(
    'Deal Apr 15- Sep15A'[DL_CLASS] = 1 &&
    'Deal Apr 15- Sep15A'[DEAL_CD] = 4 &&
    'Deal Apr 15- Sep15A'[INSTR_SUB_TYPE] IN {"EQ", "EU", "NC", "PT", "RF"},
    [SUM NET AMT Sale],
    BLANK()
    )
    RETURN
    A



Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Share some data and show the expected result.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

https://www.dropbox.com/scl/fi/q5v16m78oplgd41zi02gn/Sample.xlsx?dl=0&rlkey=lnthochv65j7zrgc1jf5yockl

You can download data from above link.                                                          

Equity Purchase - Data with other than DS,ET. IS OM,LS, ES,BD ,BN,CCD,CD,CD,CP DB,FD, GS,FD,PR ,SR,ZD from colunm (INSTR_SUB_TYPE) and DL_CLASS where 1 code and DEAL_CD with 4 code.


Equity Sale - Data with DS,ET. IS OM,LS, ES,BD ,BN,CCD,CD,CD,CP DB,FD, GS,FD,PR ,SR,ZD from colunm (INSTR_SUB_TYPE) and DL_CLASS where 1 code and DEAL_CD with 3 code.


Net Investment = Equity Purchase - Equity Sale