Forum Discussion

S184019's avatar
S184019
Advocate III
7 years ago

Circular Dependency

HELP!!!  I'm getting a circular dependency error for a single table on a column not a measure.  My two columns are: 

EHisto = if([EAvg_Min] >=0 && [EAvg_Min] <5,"<5",
if([EAvg_Min] >=5 && [EAvg_Min] <10,"5-9",
if([EAvg_Min] >=10 && [EAvg_Min] <15,"10-14",
if([EAvg_Min] >=15 && [EAvg_Min] <20,"15-19",
if([EAvg_Min] >=20 && [EAvg_Min] <25,"20-24",
if([EAvg_Min] >=25 && [EAvg_Min] <30,"25-29",
if([EAvg_Min] >=30,">30")))))))
 
and 
 
KHisto = if([KAvg_Min] >=0 && [KAvg_Min] <5,"<5",
if([KAvg_Min] >=5 && [KAvg_Min] <10,"5-9",
if([KAvg_Min] >=10 && [KAvg_Min] <15,"10-14",
if([KAvg_Min] >=15 && [KAvg_Min] <20,"15-19",
if([KAvg_Min] >=20 && [KAvg_Min] <25,"20-24",
if([KAvg_Min] >=25 && [KAvg_Min] <30,"25-29",
if([KAvg_Min] >=30,">30")))))))
 
WHAT GIVES!!
Data Modeling

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi S184019 ,

     

    Please provide sample data and desired output so that I can reproduce the same scenarion on my side.

    How to Get Your Question Answered Quickly

     

    By the way, are [EAvg_Min] and [KAvg_Min] calculated columns or original dataset columns? If it is the former, what are DAX formulas?

     

    Best regards,

    Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    S184019  - This is a good article describing strange circular dependencies with calculated columns. Are EAvg_Min and KAvg_Min measures or columns?

    Cheers!

    Nathan