Help me stop my value increasing every year.

[08Tedz40]

I need help the Total Capacity. I want it to stay 124 no mater the year. for some reason it keeps adding the total slots to every year.  so for more infromation a provider has the Total Capacity at the time of an Agreement we requested they grow the total slots. and i i cant see if they are meeting this request as the Total Capacity Requested keeps growing when their Total Capacity incareses. I dont want that. I just want the Total Capacity  requested to show the  Total Capacity  at the time of the Agreement. and never change no mater what year it is. 

so that way when u use this  i can see if they meet thier goal

 

thank you in advance 

[08Tedz40 · Accepted solution]

I was able to fix it by rewritng it the way below. 

[Anonymous]

Hi @08Tedz40 

First of all, thanks for the reply from @lbendlin. 

It seems that you have gotten a solution. Could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards    

Zhengdong Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[08Tedz40]

This is the data for the 124 shown above I have a rolling calander that creates a relationship to the date of Agreement on the Grant entites table and to report month on the master provider table  

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[08Tedz40]

hope my reply below helps 

[lbendlin]

no, it does not help.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...