Forum Discussion

grechill's avatar
grechill
Icon for Helper I rankHelper I
6 years ago
Solved

Not the usual totals calculation issue

Hello all,   I have an issue with getting the totals right.  I'm trying to do month on month comparison to define if customer has stopped paying on the contract or we have gained the customer (chu...
Need Help
  • grechill's avatar
    grechill
    6 years ago

    Ok, I have figured it out.

    I have used proposed solution by richbenmintz and added a standard tweak to fix subtotals and totals for year/quarter/month.

     

    Lost customer =
    IF(
    HASONEFILTER(dim_Customer[Customer]),
    [z_Lost Customer],
    SUMX(VALUES('Calendar'[Year Month]),[z_Lost Customer]))
richbenmintz's avatar
richbenmintz
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Hello @grechill,

See attachment, smaple.pbix

I created a customer dimension and then used the following measure

Lost Customers = CALCULATE(COUNTX('Customers', COUNTROWS('Customers')), filter('Customers', [Amount]<=0 && [Amount PM] > 0))

I hope this helps,
Richard
Have I answered your question? Mark my position as a solution!
Did my answers help come up with a solution? Give it a kudos by clicking Thumbs Up!

grechill's avatar
grechill
Icon for Helper I rankHelper I
6 years ago

Ok, I have figured it out.

I have used proposed solution by richbenmintz and added a standard tweak to fix subtotals and totals for year/quarter/month.

 

Lost customer =
IF(
HASONEFILTER(dim_Customer[Customer]),
[z_Lost Customer],
SUMX(VALUES('Calendar'[Year Month]),[z_Lost Customer]))