Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everyone,
I have a measure that returns the total number of opportunities regardless of their stages within the selected period.
Number of Opportunities = CALCULATE(DISTINCTCOUNT('Opportunities'[Id]), ALL('Opportunities'[Stage]), DATESBETWEEN('Opportunities'[CreatedDate], MIN('Calendar'[Date]), MAX('Calendar'[Date])))
I noticed one thing very strange. I have a table with all stages and the measure above as the value. The measure value should stay the name if I change the Stage filter as I have used a ALL function. However, when I choose Closed - Deal Abandoned, the value changed to 310.
What might be the reason for this? Thanks.
Solved! Go to Solution.
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,
Hopefully, this provides some new insights.
Regards,
Tom
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,
Hopefully, this provides some new insights.
Regards,
Tom
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |