Forum Discussion

MikeFleming's avatar
MikeFleming
Regular Visitor
7 months ago
Solved

FUAM DataSet

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('activitie...
admin
  • v-csrikanth's avatar
    v-csrikanth
    7 months ago

    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.

v-csrikanth's avatar
v-csrikanth
Community Support
7 months ago

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.