Forum Discussion
Calculation Rate by Year
Trying to get the Rate based on the following: 2021 SBNA RATE = IF('sz858m vwSBNAFinalATTPCnts'[Sale_Year] = 2021, 'sz858m vwSBNAFinalATTPCnts'[SBNA Volume]/SUM('sz858m vwSBNAFinalATTPCnts'[Sale...
Hello Anonymous
to delete the dependencies. 😉
WIthout knowing how your datamodel is structure there is no clear way to help you.
There is some connection between 2020 SBNA RATE and 2021 SBNA RATE. You have to go through your logic and understand where they are connected
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy