FUAM DataSet

[MikeFleming]

I am trying to link the Activities and semantic_models tables using ArtifactId = SemanticModelId

The measure is as follows:

Last Refresh Date = VAR CurrentCalc = CALCULATE( MAX('activities'[CreationDate]), 'activities'[Operation] = "RefreshDataset", TREATAS(VALUES('semantic_models'[SemanticModelId]), 'activities'[ArtifactId]) ) RETURN IFERROR(CurrentCalc, BLANK())

Can anyone see why I am getting an incorrect date in the measure?

[v-csrikanth]

Hi @MikeFleming 

I just wanted to follow up and check whether you have had a chance to verify the solutions mentioned above. Please let me know if you need any additional clarification from our end.

Thanks and regards,
Cheri Srikanth
Community Support Team.

[v-csrikanth]

Hi @MikeFleming 
Sorry for the late response.

The incorrect Last Refresh Date occurs because:

• TREATAS(VALUES(semantic_models[SemanticModelId])) can return multiple IDs
• This causes the activities table to be filtered for multiple artifacts
• MAX(CreationDate) then returns a date from an unrelated refresh

This is a filter-context ambiguity, not a data issue.

Instead of TREATAS, explicitly filter activities using a single Semantic Model ID via SELECTEDVALUE.

Last Refresh Date =
VAR SemanticModelId =
SELECTEDVALUE ( 'semantic_models'[SemanticModelId] )
RETURN
IF (
NOT ISBLANK ( SemanticModelId ),
CALCULATE (
MAX ( 'activities'[CreationDate] ),
'activities'[Operation] = "RefreshDataset",
'activities'[ArtifactId] = SemanticModelId
)
)

Let me know if the above mentioned works for you.

Thanks and regards,
Cheri Srikanth
Community Support Team.

[MikeFleming]

Thanks @v-csrikanth any suggestions as to how to fix?

[v-csrikanth]

Hi @MikeFleming 
Thank you for reaching out to the fabric community.

Yes, the issue is not with TREATAS itself, but with filter context and aggregation logic. Your measure is technically valid DAX, but it’s returning an unexpected MAX date because of how Power BI evaluates context.

Last Refresh Date :=
VAR CurrentCalc =
CALCULATE(
MAX ( 'activities'[CreationDate] ),
'activities'[Operation] = "RefreshDataset",
TREATAS(
VALUES ( 'semantic_models'[SemanticModelId] ),
'activities'[ArtifactId]
)
)
RETURN
IFERROR ( CurrentCalc, BLANK() )

Thanks and Regards,
Cheri Srikanth.