All works but I’d like to provide a button to switch from one to the other, so I created a simple measure :
ifelse(${pMeasure}=“Min”,{avg_base100},{min_base100})
I’ve an error message ( The calculation operated on Level Aware Calculation (LAC) agg expressions is not valid).
Hello,
Yes, both calculated fields work,
the issue is when I create the calculated field, by the way it works if I write something like
ifelse(test,calculation1, NULL) or
ifelse(test, calculation2, NULL) but not when I write
ifelse(test, calculation1, calculation2)
Please try using the LAC-W variant for this use case - avgOver, minOver with PRE_AGG mode.
I’m marking this as solution for now. Please let us know if you have more questions.