Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everybody, I am having some trouble with matrix. How can I check if the top level or a lower level is selected in a matrix hierarchy. I cannot use the isinscope function because I only want to process the selected item, not every item at the same level in the matrix.
Solved! Go to Solution.
Hi,@kemaley
Regarding the issue you raised, my solution is as follows:
1.You can create other measures that return values that represent hierarchy levels based on what is selected, here is my example:
Use an IF statement to check if you are at this hierarchy level and, based on your situation, use the ISFILTERED() function as an alternative technique when the ISINSCOPE() function is not available:
HierarchyLevel =
IF(
ISFILTERED('LEVEL'[class3]),
"class3",
IF(
ISFILTERED('LEVEL'[class2]),
"class2",
IF(
ISFILTERED('LEVEL'[class1]),
"class1",
"None"
)
)
)
Here's my final result, which I hope meets your requirements.
2.You can also look directly at the icons below the matrix visualization to determine, if you have expanded the hierarchy:
3.Here is the relevant documentation:
ISFILTERED function (DAX) - DAX | Microsoft Learn
Drill mode in the Power BI service - Power BI | Microsoft Learn
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It works! Thank you so much.
Hi,@kemaley
Regarding the issue you raised, my solution is as follows:
1.You can create other measures that return values that represent hierarchy levels based on what is selected, here is my example:
Use an IF statement to check if you are at this hierarchy level and, based on your situation, use the ISFILTERED() function as an alternative technique when the ISINSCOPE() function is not available:
HierarchyLevel =
IF(
ISFILTERED('LEVEL'[class3]),
"class3",
IF(
ISFILTERED('LEVEL'[class2]),
"class2",
IF(
ISFILTERED('LEVEL'[class1]),
"class1",
"None"
)
)
)
Here's my final result, which I hope meets your requirements.
2.You can also look directly at the icons below the matrix visualization to determine, if you have expanded the hierarchy:
3.Here is the relevant documentation:
ISFILTERED function (DAX) - DAX | Microsoft Learn
Drill mode in the Power BI service - Power BI | Microsoft Learn
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |