Forum Discussion
Lost Customers Calculation Formula
Hello, I use this formula below and it works fine. But if i filter and see region-wise lost customers pbi recalculates for every filter which i don't want. I need customers to be counted as lost...
Hi Anonymous,
Where did you filter the regions, and which column is it? I cannot see it in your shared screenshots.
In addition, could you share a sample pbix file with just some mock data which can reproduce the issue, so that we can better assist on it? :smileyhappy:
Regards
Hi v-ljerr-msft,
I couldn't get same results with a mock .pbix file so i share the original one :)
POL refers to regions by the way,
here is the link,
.pbix
https://drive.google.com/open?id=0B_SyDMpXEmrWamFHbGRfRDZLaFU
excel raw data
https://drive.google.com/open?id=0B_SyDMpXEmrWSFR5M2E2dWJpbGs
Thx,