Filter Expression not working

Comanchi 6 Reputation points
2022-02-24T16:32:55.36+00:00

Hi All,,
I have a dimension and one of the attribute is hidden and in the filter expression when i make the selection it is not filtering . Please see the attached screen shot, it is displaying all attributes after Miami',Please need help.
Thanks

177631-capture.png

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,284 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. CarrinWu-MSFT 6,871 Reputation points
    2022-02-25T07:58:00.407+00:00

    Hi @Comanchi ,

    Welcome to Microsoft Q&A!

    The hidden levels are visible in the user-defined hierarchy. For more information, please refer to Hiding and Disabling Attribute Hierarchies.
    177737-image.png
    Best regards,
    Carrin


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.