Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello everyone,
I have a dataset containing the Order column, date received and date shipped. I need a report where I can see the number of orders received and shipped every month and also the difference between them in order to understand how many orders are getting stucked.
But now, I have to acumulate the on hold totals, I have been trying some dax formulas but nothing seems to work, the on hold colum comes from a measure. At the end I need to have this:
Any idea? Thank you in advance.
Solved! Go to Solution.
I test this and Worked,
If i delete the "all" in the filter give me the result that you put in previous post.
TO give you another solution, Can you share a PBIX with your structure or sample?
Hi @brissae
Acum-Onhold = CALCULATE([Onhold];FILTER(all(Calendar);Calendar[Month]<= MAX(Calendar[Month])))
@Vvelarde keeps on giving me the same result:
ACUM = CALCULATE([ONHOLD],FILTER(ALL('CALENDAR'),'CALENDAR'[Month] <= MAX('CALENDAR'[Month]))) I've been trying with this measure all day but nothing changes, any other idea?
Thanks
I
I test this and Worked,
If i delete the "all" in the filter give me the result that you put in previous post.
TO give you another solution, Can you share a PBIX with your structure or sample?