Forum Discussion

KimStahl94's avatar
KimStahl94
Helper I
4 years ago
Solved

Kohort Analysis tip request

Hi there, I am trying to model a simple kohort analysis and I am facing some issues. I want to display the course of absolute customer count and percentage customer count by time. The latter one is ...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    Thank you for providing the sample file.

     

     

     

    I am working with a site filter to only include invoices that are payed.

     

     

     

    You neglected to implement that filter in the "Year of first Invoice" calculated column.

     

     

     

    Year of first Invoice = 
CALCULATE (
    YEAR ( MIN ( Invoices[date] ) ) ,
    ALLEXCEPT (
        Invoices ,
        Invoices[Customer_oid] )
    ,Invoices[Status] in {"InvoicePartlyPayed","InvoicePayed"}    )

     

     

    The background color coding doesn't work because your "% Customer Retention" measure yields a string. You would need to create another measure that computes a color value for both scenarios. 
    Color coding with DAX - Microsoft Power BI Community

     

lbendlin's avatar
lbendlin
Super User
4 years ago

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.