Well, I have the next problem.
I have this variable dimension but the problem is that when the first three conditions are not met, the third one does not act as it should.
${columns_v2_statistics.Variable} and ${columns_v2_statistics.Sub_Variable} are filters of the dashboard.
dimension: dimension_count_lvl3_3 {
type: string
sql:
CASE
WHEN ${columns_v2_statistics.Variable} = 'GEO_AREA_ID' THEN ${geo_area.municipio}
WHEN ${columns_v2_statistics.Sub_Variable} = 'COMUNIDAD' THEN ${geo_area.comunidad}
WHEN ${columns_v2_statistics.Sub_Variable} = 'PROVINCIA' THEN ${geo_area.provincia}
WHEN ${columns_v2_statistics.Sub_Variable} = 'MUNICIPIO' THEN ${geo_area.municipio}
ELSE ${value}
END ;;
}