Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Conditional expression for PRODUCTX

I had a measure which shows the number of remaining customers for each month, after counting for the predicted churn.  CALCULATE( PRODUCTX('Year Month', 1-[Churn% Last Year]), FILTER( ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , can you share formula of 

[Churn% This Year], [Churn% Last Year]

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I have a `Churn% old users` column in the `Year Month` table. So the measures retrieve the info from that column 

     

    ```

    Churn% This Year =

    SELECTEDVALUE('Year Month'[Churn% old users])

    ```

    ```

    Churn% Last Year = 

     

    var _ret = CALCULATE(
    MAX('Year Month'[Churn% old users]),
        FILTER(ALL('Year Month'),
            SELECTEDVALUE('Year Month'[År Måned LY]) = 'Year Month'[År Måned]))
    //LY column is the previous year
     
    return
        IF('Prosent Endring i Churn (gamle)'[Prosent Endring i Churn (gamle) Value] = 0,
            _ret,
                _ret*(1+'Prosent Endring i Churn (gamle)'[Prosent Endring i Churn (gamle) Value]))
    ```