DAX Calculated Measure

[Haiqal]

Hi All,

I would like to calculate the sum of my table.

My table constructured using Measure.

May I know any possible way to get it done?

Thanks you!

I need to calculate the sum of qty assigned and max cap 90%.

Thanks!

[as_Ash]

Can someone write me a DAX query which could add 2 columns in Power BI table 

Allocation based on ( Item code & First requested date.)

For Item B

• Stock Limit: 100

• Previously Used: 71 (from previous rows)

• Remaining Stock: 29

• Current Request: 30

• it only allocates 29 and for rest it would allocate 0

for balance Stock , it would follow sequestial (Good Stock - Allocation) if Allocation exceed Good stock then it would be 0

also there might be request date be same so it could allocate what is remaining to any 

Item_Code	Requested_Dt	Approved_Qty	Stock.Good Stock	Restricted Allocation	Balance Stock
A	10/12/2024	19	40	19	21
A	9/12/2025	30	40	21	0
B	9/15/2023	20	100	20	80
B	9/12/2025	51	100	51	29
B	12/1/2025	30	100	29	0
B	12/3/2025	30	100	0	0
C	9/12/2025	30	100	30	70
C	9/12/2025	30	100	30	40

[v-hjannapu]

Hi @as_Ash,
I have reproduced your requirement and implemented the solution. I have attached the PBIX file for your review so you can see the updates. Let me know if you need any changes or further improvements.

Regards,
Community Support Team.

[v-hjannapu]

Hi @Haiqal,

Thank you  for reaching out to the Microsoft fabric community forum.
If you have reviewed the questions raised by @Azadsingh and @FBergamaschi, please respond so we can provide a suitable solution based on your requirements.

Thank you.

[v-hjannapu]

Hi @Haiqal,
Could you please confirm whether your issue has been resolved? If it has not, kindly review the questions raised by Azadsingh and FBergamaschi. Please respond with any additional details or clarification needed so that we can work towards providing a solution that meets your requirements.

Best Regards,
Harshitha.

[v-hjannapu]

Hi @Haiqal,
Could you please confirm if the issue has been resolved? If so, kindly share the workaround here, as it would be helpful for other community members facing the same problem.

Best Regards,
Harshitha.

[FBergamaschi]

Hi can you please clarify

What do you mean sum of your table? You can sum a column not a table

What would a table costruite by a measure be?

And the visual you show is create how? What cloumns and measures are you using?

How does the data model look like?

[Azadsingh · Accepted solution]

Hi @Haiqal , Please share your measures for both , we can check it and enable the total for those measures.