topic Re: Tabular Reporting - Creating a Filter based on a dimension in Management & Governance

Tabular Reporting - Creating a Filter based on a dimension

Goodman_UPS — Tue, 07 May 2024 13:24:23 GMT

When trying to create a filter in the 'Filter' section of Reporting, I have trying to filter based on a dimensional value.

When I select the dimension, it just appears as my if statement in the dimension. I chose search, evaluate, etc. to find the value that I want but it keeps telling me it is invalid.

How do I filter based on a dimension

Re: Tabular Reporting - Creating a Filter based on a dimension

igoralcantara — Tue, 07 May 2024 14:05:31 GMT

It is not clear what happened. Can you share a screenshot and explain what values you expect to see?

Re: Tabular Reporting - Creating a Filter based on a dimension

Goodman_UPS — Tue, 07 May 2024 14:13:03 GMT

Thanks for looking into this. Attached a screenshot.

Re: Tabular Reporting - Creating a Filter based on a dimension

igoralcantara — Tue, 07 May 2024 14:20:44 GMT

Oh, is that a calculated dimension? I don't think that works.

Re: Tabular Reporting - Creating a Filter based on a dimension

Goodman_UPS — Wed, 08 May 2024 14:08:45 GMT

Yes, it is a calculated dimension.

Re: Tabular Reporting - Creating a Filter based on a dimension

igoralcantara — Wed, 08 May 2024 14:25:45 GMT

You will have to add the dimension to your data model. I do not believe filters in Tabular Reporting work with calculated dimensions.