Forum Discussion
Solved
Hierarchy level sum
Hi all, I am trying to do the sum from fact tables based on the different hierarchy level selected from the dimension. In the below screen on the left I have a dimension table and on the right t...
Hi TaroGulati
You need to use ISINSCOPE on the bottom layer not the top layer.Amount =
IF(ISINSCOPE('Dimension'[Sub-category] ),sum('Fact'[Amount Sub category]),sum('Fact'[Amount Category]))
Hi TaroGulati
You need to use ISINSCOPE on the bottom layer not the top layer.
Amount =
IF(
ISINSCOPE('Dimension'[Sub-category] )
,sum('Fact'[Amount Sub category])
,sum('Fact'[Amount Category])
)