Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Dear PBI community,
I am facing a topic where I want to calculate the share of an item compared to the next level of a hierarchy e.g. in a matrix visual. Let's say we have a country then region and then cities. What I want to achieve is to write a measure that detects the level at which I am currently at w/o specifying the column in the REMOVEFILTERS or ALL function. I need this because we are building reports with different combination of attributes and I do not want to write serveral measures where I have to put in all the explicit column definitions. for each combination. What I want to achieve looks like this:
REMOVEFILTERS ( <the level which is filtered by the current row in matrix> )
Is there any way to implemented this with DAX?
Cheers and thanks in advance
@Anonymous , I think isinscope can help
refer example https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM
Check out the November 2025 Fabric update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!