Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
I found the Solution:
1) In the Measure formula shown, use Distinct rather than sum
I found the Solution:
1) In the Measure formula shown, use Distinct rather than sum
User | Count |
---|---|
85 | |
76 | |
72 | |
69 | |
56 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |