Dynamic change expression measure

kwl1234 — Fri, 05 Mar 2021 07:22:50 GMT

Table 1:

Table 2:

Here my existing formula to calculate the total value based on table 1,

//company A,B,D >12MTHS

Sum({Table 2.Company-={'C'}
[> 24 MTHS]+[13-24 MTHS])

//company C >24MTHS
+Sum({<Table 2.Company={'C'},Table 2.Company -={'A', 'B', 'D'}>}
[> 24 MTHS])

Since table 1 may change, I want to change the measure dynamically, e.g if table 1 A aged ='>24MTHS', Change the formula measure to sum( [> 24 MTHS]).

Should I join table 1 and table 2 and then using if case to determine total MTHS value?

Is it a better way to calculate the total MTHS value based on table 1 column B?

Please help😥

Re: Dynamic change expression measure

kwl1234 — Fri, 05 Mar 2021 08:09:35 GMT

i seems found the solution, i use

Pick(WildMatch(

to solve this problem

topic Dynamic change expression measure in App Development

Dynamic change expression measure

Re: Dynamic change expression measure