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



Anonymous's avatar
Anonymous
Not applicable
3 years ago

Then what is the solution?