Search Filter differing in Pivot table from Multidimensional to Tabular cube/model

%3CLINGO-SUB%20id%3D%22lingo-sub-2394065%22%20slang%3D%22en-US%22%3ESearch%20Filter%20differing%20in%20Pivot%20table%20from%20Multidimensional%20to%20Tabular%20cube%2Fmodel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2394065%22%20slang%3D%22en-US%22%3EDoes%20anyone%20have%20any%20experience%20with%20Tabular%20models%20within%20Excel%3F%20Specifically%20with%20hierarchies%20with%20multiple%20levels%3F%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20I%20pull%20a%20multi-level%20hierarchy%20into%20%22Rows%22%20and%20attempt%20to%20search%20by%20clicking%20the%20drop%20down%20on%20%22Row%20Labels%22%20and%20inputting%20into%20the%20search%20bar%20no%20results%20are%20returned%20no%20matter%20what%20i%20type.%20This%20isn't%20the%20case%20for%20Multidimensional%20cubes%20or%20single%20level%20hierarchies.%20Is%20this%20a%20broken%20feature%20with%20regards%20to%20DAX%20vs%20MDX%3F%20Or%20did%20I%20miss%20a%20setting%20Somewhere%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2394065%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
Does anyone have any experience with Tabular models within Excel? Specifically with hierarchies with multiple levels?

When I pull a multi-level hierarchy into "Rows" and attempt to search by clicking the drop down on "Row Labels" and inputting into the search bar no results are returned no matter what i type. This isn't the case for Multidimensional cubes or single level hierarchies. Is this a broken feature with regards to DAX vs MDX? Or did I miss a setting Somewhere?
0 Replies