Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It is not clear what happened. Can you share a screenshot and explain what values you expect to see?
Thanks for looking into this. Attached a screenshot.
Oh, is that a calculated dimension? I don't think that works.
Yes, it is a calculated dimension.
You will have to add the dimension to your data model. I do not believe filters in Tabular Reporting work with calculated dimensions.