DAX ALL FUNCTION

Hey,

this behavior is due to data distribution in your underlying table "Opportunities" and a concept called "Auto-Exist", this article explains this concept in greater detail: https://www.sqlbi.com/articles/understanding-dax-auto-exist/

If you need more assistance to spot the cause for the unexpected result it will become necessary that you share your pbix file with the data.

Nevertheless, my recommendation,

• create a separate table that contains all the distinct values of the different stages
• link this new table to your existing table "opportunities", the new table is the one side of the new relationship
• use the new table in your measure
• use the new table to filter your data

Hopefully, this provides some new insights.

Regards,

Tom