Dynamic Measure Not Working

Looker Q&A Looker
,
1

I’m trying to create a report where users can view the Revenue by month OR the Clicks by month. I think Dynamic Measure Filters would be the way to go. I have this in my LookML but it’s not working. What am I doing wrong?

measure: revenue {
    label: "Revenue"
    type: sum
    sql: ${TABLE}.revenue ;;
    value_format:"$#,##0;($#,##0)"
}

measure: clicks {
    label: "Clicks"
    type: sum
    sql: ${TABLE}.clicks ;;
}

parameter: Measure_for_filt {
    type: unquoted
    allowed_value: {
      label: "Revenue"
      value: "revenue"}
    allowed_value: {
      label: "Clicks"
      value: "clicks"}
  }

measure: dyanmic_measure {
  label_from_parameter: Measure_for_filt
  type: number
  sql: {%if Measure_for_filt._parameter_value == "Revenue" %}  ${revenue}
 {% else %} ${clicks}
{% endif %};;    
    }
2

You have some case mismatch. Your “Measure_fo_filt” value is revenue, not Revenue. I would also avoid anything but lowercase for param names. Try this

measure: revenue {
    label: "Revenue"
    type: sum
    sql: ${TABLE}.revenue ;;
    value_format:"$#,##0;($#,##0)"
}

measure: clicks {
    label: "Clicks"
    type: sum
    sql: ${TABLE}.clicks ;;
}

parameter: measure_for_filt {
    type: unquoted
    allowed_value: {
      label: "Revenue"
      value: "revenue"}
    allowed_value: {
      label: "Clicks"
      value: "clicks"}
  }

measure: dyanmic_measure {
  label_from_parameter: Measure_for_filt
  type: number
  sql: {% if measure_for_filt._parameter_value == "revenue" %}  ${revenue}
 {% else %} ${clicks}
 {% endif %};;    
}