Forum Discussion
Hierarchy level sum
Hi all,
I am trying to sum different field based on the fields in scope in the dimension table.
In the below screen, on the left I have dimension table and on the right is the fact table:
When i put category as first level and sub category as second level in a matrix visual i want for category, sum is amount category from fact and for sub category, sum is amount sub category.
I tried using the Isinscope but it is not working.
In the attachment there is PBIX for more visibility on data.
Thanks
By default , the matrix will return what you need
So in your case, you have to add sumSubCateogry
If it is not what you are trying to achieve, can you let you PBIX in public ? (not able to download it)
5 Replies
By default , the matrix will return what you need
So in your case, you have to add sumSubCateogry
If it is not what you are trying to achieve, can you let you PBIX in public ? (not able to download it)
Hi Taro_Gulati,
Thanks for reaching out to the Microsoft fabric community forum.
Please go through the response provided by Cookistador and mark it as solution if it solves your issue.
I would also take a moment to thank Cookistador, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support TeamIf this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
Hi Taro_Gulati,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.Hi Taro_Gulati,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.
Thank you.
