topic Re: DAX Calculated Measure in DAX Commands and Tips

DAX Calculated Measure

Haiqal — Mon, 28 Jul 2025 08:46:08 GMT

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!

Re: DAX Calculated Measure

FBergamaschi — Mon, 28 Jul 2025 08:48:55 GMT

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?

Re: DAX Calculated Measure

Azadsingh — Mon, 28 Jul 2025 10:34:33 GMT

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

Re: DAX Calculated Measure

Anonymous — Tue, 29 Jul 2025 11:02:15 GMT

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.

Re: DAX Calculated Measure

Anonymous — Fri, 01 Aug 2025 11:18:34 GMT

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.

Re: DAX Calculated Measure

Anonymous — Mon, 04 Aug 2025 11:36:58 GMT

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.

Re: DAX Calculated Measure

as_Ash — Thu, 04 Dec 2025 15:35:45 GMT

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

Re: DAX Calculated Measure

Anonymous — Fri, 05 Dec 2025 05:44:18 GMT

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.