Circular Dependency

[S184019]

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!!

[Anonymous]

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

Cheers!

Nathan

[v-yulgu-msft]

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