Forum Discussion

jmorela1's avatar
jmorela1
Helper I
5 months ago
Solved

Calculate Based on Filtered Segment

I am in need of assistance to write formulas to determine

% of total customers that were repeat within same calendar year

% of total customers that were repeat lifetime

 

Needs to calcuate by respective year and product (in slicer)

 

Thanks for any help you can provide!

 

Repeat.pbix

RepeatPurchaser_B.xlsx

  • mizan2390's avatar
    mizan2390
    5 months ago

    hi jmorela1 
    I am not really sure what you actually want to do with your data. The data you have provided have aggregated value of the years along with a column Alltime. However, as SS attached, I tried to calculte. See the file wheter this solves your problem.

    Corrected file:  Repeat.pbix

     

    If this helped, please consider giving kudos and mark as a solution

    @me in replies or I'll lose your thread

3 Replies

  • FBergamaschi's avatar
    FBergamaschi
    Super User
    5 months ago

    Hi jmorela1

    I am not clear about what you are asking.

     

    Can you please explain a bit in a clearer whay what do you mean by

     

    1 % of total customers that were repeat within same calendar year

    2 % of total customers that were repeat lifetime

     

    and show examples to clarify even better?

     

    Thanks

     

    If this helped, please consider giving kudos and mark as a solution

    @me in replies or I'll lose your thread

    Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

    Consider voting this Power BI idea

    Francesco Bergamaschi

    MBA, M.Eng, M.Econ, Professor of BI

     

  • mizan2390's avatar
    mizan2390
    Super User
    5 months ago

    hi jmorela1 
    I am not really sure what you actually want to do with your data. The data you have provided have aggregated value of the years along with a column Alltime. However, as SS attached, I tried to calculte. See the file wheter this solves your problem.

    Corrected file:  Repeat.pbix

     

    If this helped, please consider giving kudos and mark as a solution

    @me in replies or I'll lose your thread