Forum Discussion

batmit25's avatar
batmit25
Frequent Visitor
2 years ago
Solved

VALUES() returning blank - Customer Churn

Hi everyone,   I'm trying to work on a Customer Churn Report and as a beginning step I need to classify customers as New,Retained and Lost for every month selected via a slicer. The logic here is t...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi batmit25 ,

    I thought of a possibility that could cause me to run fine but you can't show it. I'm using the latest version of Desktop, but when I open the pbix file you provided, it says that you are using an older version of Desktop, I suspect it's because of the version, you can try to use the newer version of Desktop and try again.

    Best Regards,

    Dino Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

batmit25's avatar
batmit25
Frequent Visitor
2 years ago

Hi Anonymous,

The DAX measures work perfectly for Retained and New Customers, However while trying to aggregate the Lost Customers value. I run into the same problem of everything being blank.

I'm not sure whether it's related to how I modeled my data but if need be I can share my report(Just a trial report). Let me know if there's anything I can add to solve this issue. 

 

Thanks again much appreciated!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, batmit25 
Yes, you can share your report with me, but please note that before you share it, please check if it contains any private information (such as account number and password, etc.), and if so, please delete it before sharing.