Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Counting Rows (leads) totaling by month

I am a newbie in Power BI. I have a database that contains monthly leads (+Lead_Import) and I am trying to do some simple calculations like CPL (Cost per Lead).  For some reason my table is calculating correctly (TTLbyMonth) for November and December but not for January through October.  Any help would be appreciated.  I have attached a copy of my table. This is my calculation:

 

TTLLbyMOnth = CALCULATE (
COUNTROWS('+Lead_Import'),
FILTER( '+Lead_Import', '+Lead_Import'[Month ]))
 
Thank you,
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, Anonymous 

     

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
     
    Best Regards,
    Community Support Team _ Janey

6 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    4 years ago

    Anonymous  Looks like you forgot to insert the link to your table - can you upload to onedrive and share here or paste directly into a post as a table so we can copy? 

     

    You shouldn't need any fancy DAX for this. Just a simple COUNTROWS(Table) used with the correct date in the visual should work, but we need to know more about your data model - do you just have the one table? 

     

    A Date table would be really helpful. https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I have a number of tables, including a date table that I have linked to my other tables . I have a table called +Lead Import that contains most of the data that I am trying to use.  I can share my model view. But the Lead Import has private information i.e. social security numbers etc. Would that work?

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Community Support
      4 years ago

      Hi, Anonymous 

       

      Since we are not clear about your specific context, we can‘t judge why your results are incorrect. We don’t know if there are duplicate values in your data or other factors that affect the results.

      If you still need help, you need to share some sample data (without privacy) and your desired result.

      You dont' need to provide real data, only a sample with similar context and some simple data.

       

      Best Regards,
      Community Support Team _ Janey