Forum Discussion
Lead Performance by Day
Hi,
The Lead Closed Table is not required for generating the Lead Performance table. Try this
- In your visual, drag the Created on Date field from the Lead Created Table
- Write this measure in the Lead Created Table
=CALCULATE(COUNTROWS(Lead_Created),Lead_Created[Closed]="Y)/COUNTROWS(Lead_Created)
Format this measure as a %.
Hope this helps.
Hi,
The Lead Closed Table is not required for generating the Lead Performance table. Try this
- In your visual, drag the Created on Date field from the Lead Created Table
- Write this measure in the Lead Created Table
=CALCULATE(COUNTROWS(Lead_Created),Lead_Created[Closed]="Y)/COUNTROWS(Lead_Created)
Format this measure as a %.
Hope this helps.
Ashish_Mathur Thanks for this. I actually manually added the "Y" to the columns. However, I can perform a Lookup to the Lead Created Table from the Lead Closed table and perform a count on the new Lookup column to get the numerator. This post has helped me to look at using the Countrows function in other situations. Thank you for the help.
You are welcome.