Totals don't adhere to Liquid conditions in SQL definition

[Vincent_Spruyt]

The ‘totals’ calculation in the Explore view generates a separate SQL query that doesn’t take into account the Liquid conditions set in the measure definition.

Below is a simple example to replicate this:

dimension: test_dimension {
    sql: "test" ;;
    type: string
}

measure: test_measure {
    sql: {% if test_dimension._is_selected %}
            100
        {% else %}
            500
        {% endif %} ;;
    type: number
}

The result:

Any ideas to work around this?

Thanks!

[elinvangbo]

This needs to be fixed ??

[sven_hermans-16]

I’m having the same issue..

[IanT]

been like this for ages sadly!