Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

S24_SimonNoer

file 'xmhierarchy.inl', line 93, function 'XMHierarchy::IsMaterialized'

Submitted by on ‎11-14-2023 05:13 AM

Hello

 

i get this error when using a measure from a fabric warehouse or lakehouse in a semantic model.

 

when i add the measure using power bi dekstop it works.

 

It seams that its the filter modifier All and Allselected that cause the issue

Status: Investigating

Hi  @S24_SimonNoer ,

 

The error you’re encountering seems to be related to the use of the and filter modifiers in your DAX measure within the semantic model. ALL/ALLSELECTEDThese functions behave differently when used as filters in CALCULATE.

ALL removes any active filters from the specified column or table ALLSELECTED returns all rows in a table, ignoring any filters that might have been applied inside the query, but keeping filters that come from outside.

The error message you’re seeing is likely coming from the ‘xmhierarchy.inl’ file, which is part of the underlying codebase. This file could be related to the hierarchy of your data model.

It’s possible that the issue arises when the semantic model tries to materialize a hierarchy that isn’t fully compatible with the and filters.ALLALLSELECTED

If the measure works in Power BI Desktop but not in the semantic model, it could be due to differences in how these platforms handle hierarchies and filters.

You might consider revising your DAX expression.

 

Best regards.
Community Support Team_Caitlyn

 

 

See more ideas labeled with:
2 Comments (2 New)
Comments
S24_SimonNoer
Regular Visitor
‎11-14-2023 05:14 AM

S24_SimonNoer_0-1699967633861.png

 

v-xiaoyan-msft
Community Support
Community Support
‎11-14-2023 10:56 PM
Status changed to: Investigating

Hi  @S24_SimonNoer ,

 

The error you’re encountering seems to be related to the use of the and filter modifiers in your DAX measure within the semantic model. ALL/ALLSELECTEDThese functions behave differently when used as filters in CALCULATE.

ALL removes any active filters from the specified column or table ALLSELECTED returns all rows in a table, ignoring any filters that might have been applied inside the query, but keeping filters that come from outside.

The error message you’re seeing is likely coming from the ‘xmhierarchy.inl’ file, which is part of the underlying codebase. This file could be related to the hierarchy of your data model.

It’s possible that the issue arises when the semantic model tries to materialize a hierarchy that isn’t fully compatible with the and filters.ALLALLSELECTED

If the measure works in Power BI Desktop but not in the semantic model, it could be due to differences in how these platforms handle hierarchies and filters.

You might consider revising your DAX expression.

 

Best regards.
Community Support Team_Caitlyn

 

 

Idea Statuses