Measure not providing Total

[ninashand]

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.  

Past Years Total = CALCULATE(sum('Opportunity Product'[TotalPrice]),Events[Past Event] <> "N")

Current Event Total = CALCULATE(sum('Opportunity Product'[TotalPrice]),Events[Past Event] = "N")

New Sales = if([Past Years Total] = 0, [Current Event Total])

Retained Sales = [Current Event Total] - [New Sales]

[ERD · Accepted solution]

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.

[ninashand]

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

[amitchandak]

@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/b...
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retenti...