Calculate Based on Filtered Segment

[jmorela1]

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 · Accepted solution]

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

[jmorela1]

@mizan2390 This was exactly what I needed. Thank you!

[FBergamaschi]

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