Forum Discussion
Circular Dependency detected!
Hi PowerBi Experts !
I have a problem I am struggling to solve even after copious amounts of research.
I am trying to create two histograms.
The data is derived from a single table on PowerBI.
The first Histogram is of the various buckets of facility size (Loans given out to businesses) and I create it by:
1) Creating a measure called "bucket"
2) Setting bucket = var temp= sum('CleanedData$'[Facility Size ]) return
if(temp<=100000,"R0 - R100000",if(AND(temp>=101000,temp<=600000),"R101,000 - R600,000",if(AND(temp>=601000,temp<=2000000),"R601,000 - R2,000,000", "R2,001,000 +")))
3) Creating a calculated column ------- Bucket Of Amount = [Bucket]
For the Second Histrogram I use the same logic/method as above but instead I create buckets showing Number of Years the business has been trading. I name the measure Bucket2
The measure is created fine but when I try create a cacluated column linked to that measure it says a circular dependency has been detected.
Any proposals on how to get around this would be appreciated.
regards
Andrew
I found the Solution:
1) In the Measure formula shown, use Distinct rather than sum
1 Reply
- adreevesNew Member
I found the Solution:
1) In the Measure formula shown, use Distinct rather than sum