Can we create a custom measure which excludes which excludes the main filters in a look?

A look created has a few main filters to derive a set of data. Can we create a custom measure which excludes the main filters used in the look, and only considers the filters specified in the custom measure? if this is not possible, is there an alternate method to derive this data?

0 2 505
2 REPLIES 2

Dawid
Participant V

Not really. The main filters as, well, main, which means they will be applied as WHERE clause and will always filter the whole query. The only way to do it would be to use all custom measures for your data but that way you won’t be able to filter a dimension (even if custom-made).

Thank you Dawid. I will try to customize all the measures, hopefully that helps.

Top Labels in this Space
Top Solution Authors