Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |