Forum Discussion
Measure not providing Total
Hi, i'm trying to distinguish new vs retained sales.
My first two measures are working as expected.
However for my final two measures receiving i'm received no total amount at all for New Sales
then receiving an incorrect total amount for Retained Sales. Help! I'm not understanding why.
Hi ninashand ,
The answer to this topic (incorrect totals for measures) can be found in this forum.
For example, DAX Formula Total is coming 0 or Correct values, but wrong total.
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
ninashand , While I need data and logic to solve this . My two blogs can help you deal with new vs retain
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458 - ERD
Community Champion
Hi ninashand ,
The answer to this topic (incorrect totals for measures) can be found in this forum.
For example, DAX Formula Total is coming 0 or Correct values, but wrong total.
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
Thank you, the first article got me there, I had to turn my measures into columns for some reason also, got there in the end! Thanks, spent a day going in circles on this. You're a legend
