Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I've Multidimensional (MD) cube with parent-child hierarchy dimension.
I put 2nd hierarchy level members into a table visual. When I was trying to filter by one of the members - nothing was changed in visual. Do you know is it a bug or something wrong in my dimension?
Screen and query caught by profiler below.
EVALUATE TOPN( 501, CALCULATETABLE( FILTER( KEEPFILTERS( SUMMARIZE(VALUES('PnL'), 'PnL'[Level 02.UniqueName], 'PnL'[Level 02.Key0], 'PnL'[Level 02]) ), OR( NOT(ISBLANK('PnL'[Level 02.UniqueName])), NOT(ISBLANK('PnL'[Level 02.Key0])) ) ), KEEPFILTERS( FILTER( KEEPFILTERS(VALUES('PnL'[Level 02.UniqueName])), 'PnL'[Level 02.UniqueName] IN {"[PnL].[Item].&[PNL#Discounts####]"} ) ) ), 'PnL'[Level 02.Key0], 1, 'PnL'[Level 02], 1, 'PnL'[Level 02.UniqueName], 1 ) ORDER BY 'PnL'[Level 02.Key0], 'PnL'[Level 02], 'PnL'[Level 02.UniqueName]
HI, @wapGO
I have tested on my side, but not reproduce the issue.
Could you share your sample pbix file for us have a test?
Best Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |