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



lbendlin's avatar
lbendlin
Super User
3 years ago

You are using measures inside your column definitions. That won't work.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago
    Equity Sales =

    VAR B =

        IF(

            'Deal Apr 15- Sep15A'[DL_CLASS] = 1 &&

            'Deal Apr 15- Sep15A'[DEAL_CD] = 3 &&

            'Deal Apr 15- Sep15A'[INSTR_SUB_TYPE] IN {"DS", "ET", "IS", "OM", "LS", "ES", "BD", "BN", "CCD", "CD", "CP", "DB", "FD", "GS", "PR", "SR", "ZD"},

            SUM('Deal Apr 15- Sep15A'[NET_AMT]),

            BLANK()

        )

        Return
        B

    If I use this instead of measure, getting the wrong values.