topic Re: count of values based on condition in DAX Commands and Tips

count of values based on condition

s_fs — Tue, 18 Mar 2025 16:18:07 GMT

I have created a table visual there I have a column which is numeric and it is weekyear like 202501,202502,202503 ... Then I have a another columns called in-hand goods and demand for the respective weekyear. Now I want to create measure how much I have covered. This measure says that my present weekyear,let say 202501 in-hand goods are 4000 and demand for 202502 is 2000 means I can survive next week with my inhand goods and then we will check for next week 202503 demand which is 1500 . So, we still can survive 202503 week also, for 202504 demand is 1000 . Now comes the point where you exhausted with your inhand stock which is 2000+1500+1000 >= 4000.now I want to count the distinct weekyear which is 3 here. Also the safe week means 202503 is the week where we are safe with our goods based on the demand.so,i need to get the sum means 2000+1500 =3500 also. Here 2 variable I need to achieve,Let me know how can I achieve this in dax.

Re: count of values based on condition

lbendlin — Tue, 18 Mar 2025 19:36:24 GMT

That's all very nice but what happens when new demand comes in, and when you restock?

DAX is incapable of doing conditional accumulations. Your only chance is Power Query List.Accumulate

Or - use a proper material planning app, rather than a reporting tool.

Re: count of values based on condition

s_fs — Wed, 19 Mar 2025 04:23:06 GMT

Hi ,as of now my data is not having restock column . the measure stock covered is based on the above variables that I have mentioned which is the count and sum of survival in hand goods.

Re: count of values based on condition

s_fs — Wed, 19 Mar 2025 04:38:52 GMT

Hi, As of now my data doesn't contain restock column . stock covered calculation I wanted to do based on 2 variables I have mentions ,I can't able to achieve those using DAX .

Re: count of values based on condition

s_fs — Wed, 19 Mar 2025 04:40:58 GMT

Hi, As of now my data doesn't contain restock column . stock covered calculation I wanted to do based on 2 variables I have mentions ,I can't able to achieve those using DAX .