Forum Discussion

Nicpet0's avatar
Nicpet0
Frequent Visitor
1 year ago
Solved

issues with RETURN statement from variables

Hi Community im trying to create a DAX calculation that evaluates invoiced quantity based on my "Selection" variable. My issue is the return statement, where it wont divide my number with 1000 whi...
DAX
variables
  • johnt75's avatar
    johnt75
    1 year ago

    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.

v-lgarikapat's avatar
v-lgarikapat
Icon for Community Support rankCommunity Support
11 months ago

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's avatar
v-lgarikapat
Icon for Community Support rankCommunity Support
11 months ago

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.