Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello!
This is my scenario. I have one table with % rates for different terms. My goal is to display a line graph that shows how the rate increases over time. So, if the rate in the first term was 1% and the rate in the second term was 2%, I want to see it it ploted as 1%, 3%.
My approach so far was to create a calculated column(Result) based on a Rate and Value columns, using the value as an index to keep adding the previous Rate to the next one. It worked so far.
My problem is that I manually entered the Rate values but want them to be dynamical, calculating them from another table where the data is.
What I tried is another calculated column that does that calculation and now I have the ActualRate.
When I tried to now substitute the new ActualRate for the original Rate in my Result column. I get a circular dependency error, so I got stuck there.
I tried replacing the ActualRate calculated column as a measure, but the thing is that it does not add the previous values, it just displays the term.
Here is my code for the Result calculated column:
This is how my columns look like:
And this is the current Result (with the measure) agains the expected Result (with the Rate calculated column):
Any help is greatly appreciated! Thank you!
Hi @Pablinho try the last part
CALCULATE(sum(Masterfile[Awarded]),Masterfile[STATUS]="GRD") * 100
put into variable and this replace in ActualRate.
Proud to be a Super User!
Hello.
Thanks for the reply. I did the change to the ActualRate column, but the error persists. This is how the ActualRate column looks now:
Hi @Pablinho is statement below return any value at all?
CALCULATE(sum(Masterfile[Awarded]),Masterfile[STATUS]="GRD") * 100
Proud to be a Super User!
Yes, it gives the correct value but only for the ActualRate column. The error comes from the Result column when I try to use the ActualRate column value instead of the Rate one.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
8 |