Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
Need your help with this problem
I have this model
The primary key for the union is the ORDER_DATE and for this calcultaion I am only using the Customers Table
The total is 1491 for new users with a web account but when I export the data and sum each day the real total is 1797.
Measures:
Solved! Go to Solution.
DISTINCTCOUNT is not additive so I wouldn't expect the total to be the sum of the values on each day. For example, if Day 1 has Customers #1, #2, and #3 and Day 2 and Customers #2, #3, and #4, then there are only 4 distinct customers for Day 1 and Day 2 combined (summing 3 + 3 would double count #2 and #3.)
You can force the total to be the sum of the parts by explicitly iterating over each day but it isn't clear to me if that makes sense in your situation or not. If you do need this, you may want to take a look at @Greg_Deckler's post here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/td-p/547907
Recommended reading:
https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/
Hi,
That answer may be correct if the same Web customer transacted on different dates.
@Anonymous Please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
DISTINCTCOUNT is not additive so I wouldn't expect the total to be the sum of the values on each day. For example, if Day 1 has Customers #1, #2, and #3 and Day 2 and Customers #2, #3, and #4, then there are only 4 distinct customers for Day 1 and Day 2 combined (summing 3 + 3 would double count #2 and #3.)
You can force the total to be the sum of the parts by explicitly iterating over each day but it isn't clear to me if that makes sense in your situation or not. If you do need this, you may want to take a look at @Greg_Deckler's post here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/td-p/547907
Recommended reading:
https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
87 | |
80 | |
69 | |
69 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |