Forum Discussion
Prior Week Sales
Hi all, I have followed this video from Enterprise DNA, https://youtu.be/jclWnA7pEvY , on how to compute prior week sales. But for some reason my output is not correct. Below is the DAX formula a...
Hmm, it works for me.
What is the formula for [Total Prospects] ?
Also, use Performance Analyzer to get the DAX code generated for the table visual, and have a look at that in DAX Studio. See if any additional filters are being applied which would need to be taken care of.
The formula for Total Prospects is
Total Prospects =COUNTA( ( Prospects[Contact ID]))
I will check the performance analyzer. How can i upload a file?