# How to filter the result from specific formula?

**URL:** <https://community.eazybi.com/t/how-to-filter-the-result-from-specific-formula/19225>\
**Category:** Questions & Answers\
**Created:** [December 11, 2024, 10:44am UTC](https://community.eazybi.com/t/how-to-filter-the-result-from-specific-formula/19225 "2024-12-11T10:44:32Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [December 12, 2024, 9:27am UTC](https://community.eazybi.com/t/how-to-filter-the-result-from-specific-formula/19225/2 "2024-12-12T09:27:50Z")

</div>

Hi @Newbyhehe

Dealing with multi-value field dimensions such as “Label” is always tricky.  
Some Jira issues can have more than one label, so it is almost challenging to exclude just one, and keep the other, and at the expect correct results for measures in report.

Please share more details about the use-case and the formula for the calculated member “Testing” in the Label dimension.  
What measures do you want to calculate exactly (count, average, sum, etc.), and what other dimensions do you use in the report?

Here is one use case with Label as CSV dimension that creates all possible label combinations in new dimension as dimension members. That would let you use it as a single-value dimension, and then aggregate + except would work much simpler.

> [@Get issues that have two labels (both labels)](https://community.eazybi.com/t/get-issues-that-have-two-labels-both-labels/4568/6):
>
> @staunk Try using lowercase label names “label-1” and “label-2” in the formula. eazyBI imports label names in lowercase. Martins / eazyBI

Martins / eazyBI

---

_[View the full topic](https://community.eazybi.com/t/how-to-filter-the-result-from-specific-formula/19225)._