Forum Discussion

julius_kr's avatar
julius_kr
Frequent Visitor
2 years ago

YoY-Sales Lost Customer Measure

Good morning, 

 

I am trying to create a waterfall chart like in this YouTube video: Power BI: How to Write any DAX Measure In Just 3 Easy Steps 👣 (youtube.com)
I have no problems with Declining, New and Growing YoY Sales by Customer, but I can't get Lost Customer YoY Sales to work.


If I put the customerID, YoY-Sales and sales growth % into a table and manually filter by -100% sales growth, I get the correct values for lost customer YoY-Sales.

But when I try to use my measure I just get no values at all. 

CustomersLost =
CALCULATE(
    [Sales YoY],
    FILTER(
        VALUES('Sales'[CustomerID]),
        [Sales Growth %] = -1
    )
 
If I adjust the "-1" this measure works for the other three cases.
I have tried many different things, but at this point i am just desperate.
Need Help

2 Replies

    • julius_kr's avatar
      julius_kr
      Frequent Visitor
      2 years ago

      Thank you for your help, but I am still not getting any values.

      I used your YoY approach and it works great, but the measure still doesn't work. Is it possible that the measure is just wrong?

      What could be causing this, because all the other three measures are working fine.

      Or is it possible to use the manually calculated value from the table in some way?