CASE WHEN with Boolean and multiple matches

Hello @Michael,

If “Brand” is a multivalue field, then my described solution won’t work.
For a multivalue field, the easiest and fastest solution would be to import your Brand Dimension as a CSV dimension.

My colleague has described how to import it for the Label dimension, but you can apply the same logic for your “Brand” custom field as well: Jira JQL in EazyBI Custom Measure as a Filter

If there are any issues, let me know.

Best,
Marita / support@eazybi.com