Ratio Calculation between two user-selected columns

[bcmoulam]

Hi all, 

Ref example table below. Various numeric metrics for each month - there are about 30 total columns similar to the examples (events, defects etc.)

Date	events	defects	delays	cycles	defects/cycles
Jan-22	111	92	32	2431	0.038
Feb-22	117	85	9	2162	0.039
Mar-22	40	74	33	2356	0.031
Apr-22	60	73	38	2820	0.026
May-22	122	89	13	2320	0.038
Jun-22	92	71	40	2140	0.033
Jul-22	41	91	21	2617	0.035
Aug-22	106	73	30	2830	0.026
Sep-22	53	63	24	2968	0.021
Oct-22	38	60	17	2906	0.021
Nov-22	148	62	6	2055	0.030
Dec-22	110	60	28	2887	0.021
Jan-23	130	62	40	2513	0.025
Feb-23	132	90	26	2198	0.041
Mar-23	117	99	29	2655	0.037
Apr-23	39	85	39	2018	0.042
May-23	66	84	28	2947	0.029
Jun-23	141	95	22	2313	0.041
Jul-23	62	82	15	2581	0.032

I'd like to calculate ratio's between the columns based on user-input - I'm imagining two filters titled Numerator & Denominator. The two filter values are passed to a Measure(?) that then calculates the ratio for each row. In the above example the user would have selected 'defects' in the Numerator filter and 'cycles' in the Denominator filter. That result is then plotted in a line chart over time.

I know I can create loads of calculated columns to do this up-front for all the possible combinations, but was wondering if possible to do this dynamically based on user input?

I've looked at other similar articles but they don't quite fit what I'm after - any help appreciated. 

Thanks

[bcmoulam]

Perfect, thanks Amit!

[amitchandak · Accepted solution]

@bcmoulam , This is the old measure slicer way, You have to create two such tables and slicer and then create combined measure using a divide

How to create a Measure Slicer: https://youtu.be/b9352Vxuj-M