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 ...
  • 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