Forum Discussion
Combine switch functions - hierarchy
- 2 years ago
Maybe you just need to re-enable row totals?
IF(
ISINSCOPE(Trending[Sub measure]),
Measures are never in scope.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Thank you for the feedback, in hindsight I see I didn't provide enough information. I changed the naming of all variables, tables, measures and values. So nothing is blacked out anymore and the entire measure is now visible.
Related to your reply regarding measures not being in scope. That would be correct, but I named the column a bit vaguely as it is not referring to a measure but the names of the variables. The provided value within
IF(
ISINSCOPE(Trending[Sub var]),
refers to a table[column] reference, so that shouldn't be the issue here