Data model hierarchy

[bilibi2928]

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?

[Anonymous · Accepted solution]

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.