DAX Calculated Measure

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.

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?

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