Forum Discussion
issues with RETURN statement from variables
I don't think that this is calculating what you want it to. The Total, Selection and External variables will not be recalculated for each iteration of Company Name. In DAX variables are not really variable, they are constants which are only calculated once.
If you wish to recalculate for each company then you would need to move the variables inside the SUMX.
Community SupportHi Nicpet0 ,
Thanks for reaching out to the Microsoft fabric community forum.
johnt75 , bhanu_gautam ,
Thanks for your prompt response
wanted to follow up and confirm whether you’ve had the opportunity to review the information provided by johnt75 , bhanu_gautam . If you have any questions or need further clarification, please don’t hesitate to reach out.
We appreciate your collaboration and support!
Best regards,
Lakshmi.
- v-lgarikapat
Hi Nicpet0 ,
We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.
We appreciate your engagement and thank you for being an active part of the community.
Best Regards,
Lakshmi.- v-lgarikapat
Hi @Nicpet0 ,
We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.
We appreciate your engagement and thank you for being an active part of the community.
Best Regards,
Lakshmi.