Forum Discussion
Data model hierarchy
I am working with a data model that includes a hierarchy of product categories. How can I use expressions to create measures that aggregate data at different levels of the hierarchy, such as by product, product category, or overall sales?
Hi bilibi2928 ,
Please try to create a measure with ISINSCOPE() function.
For more details, you can read related document: ISINSCOPE function (DAX) - DAX | Microsoft Learn
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi bilibi2928 ,
Please try to create a measure with ISINSCOPE() function.
For more details, you can read related document: ISINSCOPE function (DAX) - DAX | Microsoft Learn
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.