User Profile
hailey185
Regular Visitor
Joined 3 years ago
User Widgets
Contributions
Re: Calculate the Sum of a column, depending on hierarchy
Hi CNENFRNL ! How can I change the line at "Type" and "Code" level if I want to have the results at "Type" equal sum of "Probability" defined in the previous ISINSCOPE clause? With the same logic, I would like to see results at "Code" level equal sum of "Type". I have tried this but it did not show correct total amount at "Type" and "Code" level. Segmentation = SWITCH ( TRUE (), ISINSCOPE ( 'Fact'[Product] ) || ISINSCOPE ( 'Fact'[Course] ), [Pop x Grade], ISINSCOPE ( 'Fact'[Probability] ), SUMX ( VALUES ( 'Fact'[Course] ), [Pop x Grade] ), ISINSCOPE ( 'Fact'[Type] ), SUMX ( VALUES ( 'Fact'[Probability] ), [Pop x Grade] ), ISINSCOPE ( 'Fact'[Code] ), SUMX ( VALUES ( 'Fact'[Type] ), [Pop x Grade] ) ) Thank you in advance!!3.6KViews0likes0Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.