topic Re: Calculate Based on Filtered Segment in DAX Commands and Tips

Calculate Based on Filtered Segment

jmorela1 — Thu, 26 Mar 2026 20:58:24 GMT

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

Re: Calculate Based on Filtered Segment

FBergamaschi — Fri, 27 Mar 2026 07:19:53 GMT

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

Re: Calculate Based on Filtered Segment

mizan2390 — Sun, 29 Mar 2026 09:27:16 GMT

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

Re: Calculate Based on Filtered Segment

jmorela1 — Mon, 30 Mar 2026 16:22:59 GMT

mizan2390 This was exactly what I needed. Thank you!